I have a query which is pulling data from another program. I am bringing in
account balances and the date of that balance. Somewhere in the process,
either how the other system stores the date or how Query imports, I am
getting the serial number of the date rather than the date format I am used
to seeing. How can I convert the serial number to a date format ie 12/31/04.
changing the format doesn't work. Thanks.