Change Date Format

[AT76]

Hi,

I brought a table from AS400 to access. It brought a particular column as a "NUMBER" data type. The Format of the field is: YYYYMMDD.

Is there a way to change this field (perhaps thru a query to DDMMYYYY and change the data type to "DATE"

Thank you!

 

[SkipVought]

Hi,

Your YYYYMMDD STRING is not a REAL DATE in MS Access. It must be CONVERTED to a Date Serial Value using the DateSerial Function

DateSerial(Left([AS400String],4),Mid([AS400String],5,2),Right([AS400String],2))

this value can then be displayed in a number of formats.


Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
Poultry in motion to pullet for a paltry amount!}

 

[AT76]

Thank you!! Works Great!