Robb wrote: > Hi, > > Does anyone have any idea what is up with Microsoft Access and its > ridiculous Date/Time formatting options?
:) In VB, I use the format: #dd-mmm-yyyy HH:mm:ss# Your example: $dt = "#4/5/2004 5:3:45 PM#"; I would write as: $dt = "#04-MAY-2004 17:03:34#"; You have to pad your numbers. You can't just use "5:3:45" and expect Access ( or others ) to know what you want. Converting the month to a 3-character string version forces Access to recognise the 1st part as the day and the last part as the year. If you don't do this, it's selection of day/month/year positions appears to be random. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au
