YYYYMMDD

[Guest]

I have a date table that currently stores dates in a YYYYMMDD format. The problem I am encountering is that when I go to extract the date via ASP, to be displayed, it is returned in the format MM/DD/YYYY. The same issue exists whenever I click on the data inside my table. Is there a way (outside of the regional settings I've read about) to keep the format the way I'd like it to be

Thanks for your time and assistance.

 

[Douglas J. Steele]

Format only affects how the value is displayed, not how it's stored. Dates
are stored as 8 byte floating point numbers, where the integer part
represents the date as the number of days relative to 30 Dec, 1899 (and the
decimal part represents the time as a fraction of a day). In other words,
dates aren't stored with any particular format.

Your only option is to explicitly format the date when you extract it. I'm
not sure whether setting a format for the field in the table (in Table
Design mode) will affect its format when you extract it through ASP, but it
should for when you're working with the date within Access

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have a date table that currently stores dates in a YYYYMMDD format. The

problem I am encountering is that when I go to extract the date via ASP, to
be displayed, it is returned in the format MM/DD/YYYY. The same issue
exists whenever I click on the data inside my table. Is there a way
(outside of the regional settings I've read about) to keep the format the
way I'd like it to be?