Title: Getdate format
|
Hi
again
This may seem
trivial but it's the only way I can get GETDATE to
work.
SET DATE MM/DD/YYYY
SET VAR
vGetDate = (GETDATE('Select Date'))
SET
VAR vmth INT = (IMON(.vGetDate))
SET VAR vday
INT =
(IDAY(.vGetDate))
SET VAR
vyear INT = (IYR(.vGetDate))
SET DATE DD/MM/YYYY
SET VAR
vGetDate = (.vday
& .vmth
& .vyear)
Lucas
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 -----
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
|
