Custom Date Format

[Brian T]

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

Thanks

 

[Kipp Woodard]

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]

thanks

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")

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

Thanks