Format Date Help

[turks67 via AccessMonster.com]

Is there a way to format the date 12/31/2008 to 0081231? I have tried every
which way.

Thanks.

 

[Douglas J. Steele]

Assuming it's a date field (as opposed to a text field that's holding a
date), and that you really meant 0081231 (and not 20081231), try:

Right(Format([TheDateField], "yyyymmdd"), 7)

If 0081231 is a typo, leave out the Right( and , 7)

If it's a date in a text field, use the CDate function to convert it to a
date. Note, though, that that won't work for users who have their Short Date
format set to dd/mm/yyyy

 

[turks67 via AccessMonster.com]

Thank you again.

Assuming it's a date field (as opposed to a text field that's holding a
date), and that you really meant 0081231 (and not 20081231), try:

Right(Format([TheDateField], "yyyymmdd"), 7)

If 0081231 is a typo, leave out the Right( and , 7)

If it's a date in a text field, use the CDate function to convert it to a
date. Note, though, that that won't work for users who have their Short Date
format set to dd/mm/yyyy

Is there a way to format the date 12/31/2008 to 0081231? I have tried
every
which way.

Thanks.