Albert, You are right it works on an individual level. But if I try to update all the columns in one go I receive an error message
update IPT_Import_Care set ZZG_Enddate = ZZG_Enddate_T -ERROR- Expression does not return a valid DATE. (2158) -INTERNAL ERROR- Out of dynamic space ZZG_Enddate column with date setting ZZG_Enddate_T column with text setting Tony -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Albert Berry Sent: vrijdag 28 maart 2014 4:39 To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Date problem while importing Excel sheet 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. >
