Removing date Separator

[willfindaway]

My date field in my access database is currently in this format: 2001/01/01. Is there a way to convert it to 20010101 without the separators.

Thanks again for your help.

 

[TheAceMan1]

How are ya willfindaway . . .

In the [blue]Format[/blue] property of the field, enter [blue]yyyymmdd[/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[SkipVought]

will,

You do realize that this is ONLY a Display thing. Date/Time values are just NUMBERS, like right now in North Texas the Date/Time value is 39946.21673, which can be FORMATTED any number of ways, like 5/13/2009 5:12 or 20090513.

But the VALUE is still 39946.21673.


Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}