Shamil Salakhetdinov
shamil at users.mns.ru
Fri Jan 12 17:14:57 CST 2007
<<< ? I've tried CDate([MyNumber] >>> Hello Gale, Cdate([MyNumber]) Where [MyNumber] should work OK is [myNumber] is a well formed number... Maybe you've just missed trailing round bracket in your update query? <<< and Format([MyNumber,"mm/dd/yyyy") >>> Here square bracket is missing... -- Shamil -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gale Perez Sent: Saturday, January 13, 2007 12:43 AM To: accessd at databaseadvisors.com Subject: [AccessD] Convert Clarion Serial Date to Access Normal Date Hello! I have been given an Access table, exported from Clarion, with a date field containing a serial number representing the date. I understand that the Clarion date begins December 28,1800, and that Access begins with December 31, 1899, or 36162 days later. I created a query to update the Clarion date to ClarionDate-36162 (although i've also seen advice to subtract 36161 - I'll know which is right once I've converted the serial to a date), but how do I convert that serial number to a regular date? I've tried CDate([MyNumber] and Format([MyNumber,"mm/dd/yyyy") (and I've tried rearranging the days, months and years in the Format function), but to no avail. Could someone please advise me how to do this? Thank you very much for any suggestions, Gale -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com