My finding was that is was actually null
Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 131 30 Nacka Sweden -----Ursprungligt meddelande----- Från: [email protected] [mailto:[email protected]] För Dan Skickat: den 13 augusti 2009 17:08 Till: RBASE-L Mailing List Ämne: [RBASE-L] - RE: GETDATE Jim, if you escape the date picker, the variable isn't set at all. it is'nt null or = '[esc]'. Check to see if the variable exists after the set. Dan At 10:51 AM 8/13/2009, you wrote: Jim, Maybe try SET VAR Date_A date=(GETDATE('Pick Processing Start Date')) Dave Fitts State of Maine _____ From: [email protected] [ <mailto:[email protected]> mailto:[email protected]] On Behalf Of Jim Belisle Sent: Thursday, August 13, 2009 8:35 AM To: RBASE-L Mailing List Subject: [RBASE-L] - GETDATE I use the GETDATE command to bring up the calendar so people can choose the date. Does the CANCEL button give the same value as the Escape key in my variable below? Should I use IF Date_A = [Esc] instead of the IS NULL in my IF THEN statement? SET VAR Date_A = (GETDATE('Pick Processing Start Date')) IF Date_A IS NULL THEN SET VAR vAbort = 1 PAUSE 2 USING 'OPPERATION ABORTED!' BREAK ENDIF The above code works in RBEDIT mode but not from the R prompt. I get a SET error. What am I doing wrong? Jim
