Back to SPR List Previous Next
New "exact" datemap feature added
New Feature Closed - Feature Found:XS.01.07 19 FEB 2008 Fixed:XS.01.08 19 FEB 2008

DETAILS
 A date map that starts with "E" will force the entered date to match the datemap
 exactly. The E is not a part of the format but indicates that the remainder of the
 string is an exact map.

 This prevents dates being entered as a single digit and defaulting to the current year.
EXAMPLE PROGRAM
 program
 Date d ('ddmmyy')
 Date d1 ('dd/mm/yy')
 Date e ('Eddmmyy')
 Date e1 ('Edd/mm/yy')
 Compute d='011206'
 Compute d1='011206'
 Compute e='011206'
 Compute e1='011206'
 write d d1 e e1
 Compute d='01/12/06'
 Compute d1='01/12/06'
 Compute e='01/12/06'
 Compute e1='01/12/06'
 write d d1 e e1
 Compute d='1 12 6'
 Compute d1='1 12 6'
 Compute e='1 12 6'
 Compute e1='1 12 6'
 write d d1 e e1
 end program
WORKAROUND
In PQLForms you could use an editin clause to check the format of the entered string to see that it specified the whole date.
Back to SPR List Previous Next