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