Sign in to follow this  

Date Format in SQL Query

Recommended Posts

Hey, i have a 'lil problem, when i began my app, i decided to put every Date Field as a Text field in the Access Database. But now my app is given me a hard time when i wanna test if something is between date1 and date2 or just to order by date! i've searched a lot and didnt find an example of what im trying to do. all my date are saved in this format : dd-mm-yy Is there a way I could do something Like "Select * From Table Order By SomeFunctionThatConvertsToDate([myDate]);" ?? thanks

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this