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])
 
Back
Top