How to change yyyymmdd number field to a date field

M

mcin7535

How can I format a number field in a table that has the data formated
like yyyymmdd into a date field using a query?
 
S

Stefan Hoffmann

hi,
How can I format a number field in a table that has the data formated
like yyyymmdd into a date field using a query?
Click to expand...
You can't format it. But you can build it:

DateSerial(Mid([Field], 1, 4), Mid([Field], 5, 2), Mid([Field], 7,2))



mfG
--> stefan <--
 
D

Douglas J. Steele

Stefan Hoffmann said:
hi,
How can I format a number field in a table that has the data formated
like yyyymmdd into a date field using a query?
Click to expand...
You can't format it. But you can build it:

DateSerial(Mid([Field], 1, 4), Mid([Field], 5, 2), Mid([Field], 7,2))
Click to expand...

Or CDate(Format([Field1], "####\-##\-##"))
 
M

mcin7535

How can I format a number field in a table that has the data formated
like yyyymmdd into a date field using a query?
Click to expand...

Ok, the build option worked! Thanks for the help!
 
Top