Actually it works that way just the same. Canada is half and half -
officially dd/mm/yyyy, but being next door to mm/dd/yyyy we never know
what to expect.
R>SET DATE DD/MM/YYYY
R>SET VAR vDateText TEXT = '30/06/2014'
R>set var vdate date = .vDateText
R>show var
Variable =
Value Type
-------------------------------- ------------------------------
-------
#DATE =
27/03/2014 DATE
#TIME =
21:36 TIME
#PI =
3.14159265358979 DOUBLE
SQLCODE =
0 INTEGER
SQLSTATE =
21S01 TEXT
#NOW = 27/03/2014
21:36 DATETIME
vDate =
30/06/2014 DATE
vDateText =
30/06/2014 TEXT
On 3/27/2014 1:00 PM, Tony IJntema wrote:
Thank you all for your support.
Albert, I think that one of my problems is the date setting. In Holland
commonly the setting dd-mm-yyyy is used.
>From a long time ago I can remember that there was no issue converting text
to date if dd/mm/yyyy is used.
