Title: | *OLD* ALL-IN-1 (tm) Support Conference |
Notice: | Closed - See Note 4331.l to move to IOSG::ALL-IN-1 |
Moderator: | IOSG::PYE |
Created: | Thu Jan 30 1992 |
Last Modified: | Tue Jan 23 1996 |
Last Successful Update: | Fri Jun 06 1997 |
Number of topics: | 4343 |
Total number of notes: | 18308 |
Subject: Concerning date validation My customer wants to validate the date entered in the REQUESTED_COMPLETION_DATE field on an entry form. That is later than the current date. ... field named date currently ;;REQUESTED_COMPLETION_DATE;; /VALID=CAL$SET_DATE:"REQUESTED_COMPLETION_DATE"/LANGUAGE=NBS_DATE /POST="DATE_CONVERT REQUESTED_COMPLETION_DATE,REQUESTED_COMPLETION_DATE,2,2 .. can I or how would I add the validation to assure field is greater than current date OA$DATE? thanks, Reda
T.R | Title | User | Personal Name | Date | Lines |
---|---|---|---|---|---|
3727.1 | How about ... | IOSG::MAURICE | I left my heart in Alcatraz | Tue Jan 04 1994 17:44 | 23 |
Hi, One way would be to add field post processing. Something like /POST='XOP ~~REQUESTED_COMPLETION_DATE_POST~~' on the field, and then: ;;~~REQUESTED_COMPLETION_DATE_POST~~;; .IF REQUESTED_COMPLETION_DATE NES "" THEN DATE_CONVERT REQUESTED_COMPLETION_DATE, REQUESTED_COMPLETION_DATE, 3\\ DATE_CONVERT #REQ_COMPLETION_DATE_NBS, REQUESTED_COMPLETION_DATE, 7\\ .IF #REQ_COMPLETION_DATE_NBS LES OA$DATE_NBS THEN OA$VAL_SET_INVALID\\\\ OA$FLD_STAY REQUESTED_COMPLETION_DATE\\\\ GET OA$DISPLAY = "You must specify a future date and time" HTH Stuart |