converting string to date

  • Thread starter Thread starter dana livni
  • Start date Start date
D

dana livni

Could anyone help me with the following:
I have a field in my access database in a string format and i need to
convert it into a date in order to comper it to other dates.
the format of the data is 01-jun-03.
This needs to be done in an inline SQL function that will be used in a
SQL statement.
Any help would be GREATLY appreciated.

Thanks,
dana livni
 
dana livni said:
Could anyone help me with the following:
I have a field in my access database in a string format and i need to
convert it into a date in order to comper it to other dates.
the format of the data is 01-jun-03.
This needs to be done in an inline SQL function that will be used in a
SQL statement.
Any help would be GREATLY appreciated.
Click to expand...

DateValue([YourField])
or
CDate([YourField])
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converted from LINUX time ok, but having issues with the between date. 4
#error - Blank 3
Windows 7 I need to convert date to text 3
Numeric Field Overflow when appending date - how to convert it to text 1
Access pass-through query, SQL-92 combining strings: '&' does not 4
Convert and sort date originally formated as text 3
Converting a date to a string 1
Convert Date string to date format 7

Back
Top