Custom Date Format

External Since: Sep 23, 2009 Posts: 2

How do I create a date format? I need the format to be: YYYYMMDD.

Thanks

External Since: Sep 23, 2009 Posts: 1

The format you want is simply "YYYYMMDD".

Where are you going to use it? If it is for a text control on a form, then
set the Format property of the control to yyymmdd, with no quotes.

If you want to format a column of query, then you would do it thus:

Select Format([MyDateColumn], "yyymmdd") From MyTable

In VBA it would be similar:

strFormattedDate = Format(dtMyDateVariable, "yyymmdd")

"Brian T" wrote:

> How do I create a date format? I need the format to be: YYYYMMDD.
>
> Thanks