Re: Getdate format

[Clive Williams]

Title: Getdate format

In Australia a new installation of MYOB will sometimes display the date in the mm/dd/yy format even though the regional preferences have been set to dd/mm/yy - the way to fix it is to go into the regional settings in the control panel and change the format to dd/mm/yyyy and it then works fine - a long shot but it is worth a try.   Regards Clive Williams CRW Services Silverdale NSW ----- Original Message ----- From: Edwards Lucas To: [EMAIL PROTECTED] Sent: Thursday, January 24, 2002 9:47 AM Subject: Getdate format Hi All GETDATE function in 6.5++ works fine. However, unless I set the RBase date format to MM/DD/YYYY or pick a date between 1-12 of the month it doesn't return a valid date. Windows short date format is set to DD/MM/YYYY which is default for Australia and is what I want to stay with. What am I missing here? Thanks Lucas