Access 2003 Date Conversion

[smorgan77]

I have a linked table from SQL 2005 and the date format is YYYY-MM-DD HH:MM:SS. I need to populate an Oracle table with the date, but the format is different, it's YYYYMMDD. I can't find the correct way to convert this in Access.

 

[Andrzejek]

If in both databases your date filed are declared as Date, you don't need any conversions, I think. Date is stored in DB as number anyway, it is just displayed to us, people, in the format we can recognized.

Have fun.

---- Andy