converting Date from DD/MM/YYYY to YYYYMMDD

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
Back
Top