SQL Formatting of Date

[HRISUser]

I am trying to convert a date that is currently stored as a timestamp to a string but I need to have it come back in the following format YYYYMMDD. Right now I am using the following
CStr ({Table.Field}) this converts the field to a string but doesn't report it in the correct format.
Any help would be greatly appreciated.
Thanks

 

[PHV]

Have a look at the Format function:
Format(Table.Field, "yyyymmdd")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886