[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Fighting with Invalid Dates
- Subject: Fighting with Invalid Dates
- From: chandrashekhar jinna <csjinna@YAHOO.COM>
- Date: Wed, 27 Feb 2002 16:30:36 -0800
Hi Friends,
I am trying to make a chaeck on the following
operation. I have to check the date of birth of a
student and should throw an error message it was
working fine now the req is I need to check the null
values also and throw the same kinda message.
I have implemeted the following logic, But I donno why
it is throwing an invalidate error from the
application processor. Do lemme know if I am wrong
somewhere.
I appreciate your help.
Global string &ID;
Global any &BIRTHDATE;
If %PanelGroup = PANELGROUP.PAYMENT_PLAN And
%Mode = "A" Then
&ID = EMPLID;
SQLExec("SELECT BIRTHDATE FROM PS_PERSONAL_DATA WHERE
EMPLID = :1", &ID, &BIRTHDATE);
If (&BIRTHDATE Not = "NULL") Then
If (AddToDate(&BIRTHDATE, 18, 0, 0) > %Date) Then
WinMessage("The student you have selected is less than
18 years old. Press OK to continue cancel to suspend
the current operation.", 1 + 32, "Warning");
End-If;
Else
WinMessage("The student you have selected has no
Birthdate. Press OK to continue or cancel to suspend
the current operation.", 1 + 32, "Warning");
End-If;
End-If
__________________________________________________
Do You Yahoo!?
Yahoo! Greetings - Send FREE e-cards for every occasion!
http://greetings.yahoo.com