Custom Date Format

  • Thread starter Thread starter Brian T
  • Start date Start date
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")
 
thanks

Kipp Woodard said:
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 said:
How do I create a date format? I need the format to be: YYYYMMDD.

Thanks
Click to expand...
Click to expand...
 
Back
Top