Dates - Calculations in access from imported data (1 Viewer)

[alcifer_c]

Good day,
Need to use something along the lines of date-1 on a linked ODBC table. Problem is that the date is a numeric format displaying: yyyymmdd.
The fact that it is numeric makes it easy for calculations, but not if I want to compare to date() as it is in access.

Thanks for any suggestions,

Al

 

[Mile-O]

You can create a calculated date field:

i.e.

MyDate: DateSerial(Left([DateField], 4), Mid([DateField], 5, 2), Right([DateField], 2))

 

[alcifer_c]

Splendid!!

Now my plans to take over the world are almost complete...

Thanks, Al