using date format 1

[Serpno11]

I have imported date fields that are numbers with YYYYMMDD format.

What function and what is its syntax (parameters) can I use to convert it to a date field or value?

I want to be able to add 7 and 14 days to the resulting field or value.

 

[Anubis3000]

Go into the MS Access help menu and search for "DateAdd". That should give you all the answers you need.

 

[Serpno11]

Anubis3000,

Thanks for your prompt reply. I am familiar with the DATEADD fcn, but my problem is that the data are numeric where today is the equivalent of 20,050,207. How do I get that into a true date format? Can I convert it to a STR then use another function? Thanks again for all your help!!

 

[PHV]

A starting point:
DateSerial(Left(theField, 4), Mid(theField, 5, 2), Right(theField, 2))

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