Converting a date

Guest · Jun 30, 2005

How do I convert a date from 6/28/2005 to 20050628?

Guest · Jun 30, 2005

Try this
Format([DateField],"yyyymmdd")

Guest · Jun 30, 2005

Format(Date(), "YYYYMMDD")

Substitute your date field for Date().

HTH
Dale

Guest · Jun 30, 2005

Thankyou

Ofer said:
Try this
Format([DateField],"yyyymmdd")

Dogwood said:

How do I convert a date from 6/28/2005 to 20050628?

Click to expand...