UtterAccess Discussion Forums > Convert text date to date format

Full Version: Convert text date to date format

UtterAccess Discussion Forums > Microsoft® Access > Access Queries

swaziman1

Nov 7 2007, 05:10 AM

Hi,

I have a table where the month field shows as eg.'Nov-07' , however this is a text field
and I want to convert it to a Date/Time field but still have it show as mmm-yy,
does anyone have any suggestions how I can do this? I have tried cDate but this just gives me an error.

Thanks

Peter46

Nov 7 2007, 05:15 AM

Cdate("01-" & fieldname)

swaziman1

Nov 7 2007, 05:26 AM

perfect , thanks

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.