| 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
| |||||