How do I convert a date from 6/28/2005 to 20050628?
D Dale Fye Jun 30, 2005 #3 Format(Date(), "YYYYMMDD") Substitute your date field for Date(). HTH Dale
D Dogwood Jun 30, 2005 #4 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... Click to expand...
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... Click to expand...