Convert Date YYYYMMDD

[mattc66 via AccessMonster.com]

Hi All,

I need to convert using a query the date format from MM/DD/YYYY to YYYYMMDD.

How do I do this?

Thanks
Matt

 

[KARL DEWEY]

Format([YourDateField], "yyyymmdd")

 

[fredg]

Hi All,

I need to convert using a query the date format from MM/DD/YYYY to YYYYMMDD.

How do I do this?

Thanks
Matt

If the field is a date datatype field, you don't need to do anything.
A field's format has nothing to do with what is stored, just with the
way it is displayed.
Simply set the field's format property to
yyyymmdd
wherever you display it.