converting Date from DD/MM/YYYY to YYYYMMDD

G

Guest

I have read many threads about how to convert Date from YYYYMMDD to
DD/MM/YYYY format, can anyone help me to do the reverse? That is, I have some
Date data like 27/05/1979 and I want convert it to 19790527. Is this
operation possible in Access or Excel? Thanks in advance.
 
B

Brendan Reynolds

Assuming the date is stored in a date/time field or variable ...

Format$([YourDate] "yyyymmdd")

For example, in the Immediate window ...

? Format$(Date(),"yyyymmdd")
20051101
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel date format YYYYMMDD 1
YYYYMMDD question 4
how do I change the date format from yyyymmdd to mm/dd/yyyy 4
Forcing a date entry format of dd/mm/yyyy 1
Need to convert MMDDYY to YYYYMMDD! Help please! 3
How to enter a date in DD-MM-YYYY format 2
Convert yyyymmdd format to dd-mm-yyyy 4
Changing mm/dd/yyyy To yyyymmdd 5

Top