Date Constraints

  • Thread starter Thread starter RichardY
  • Start date Start date
R

RichardY

How do I setup a constraint for a date field where the user must enter
date that is after another date?

For example,

A unit was lent out on Dec. 1, 2003. Therefore the return date must b
Dec. 1'03 or after Dec. 1'03. What do I have to do in order to create
error message that will pop-up when an incorrect return date i
entered
 
The way I handle it is on the form design to make the Property of th
one field, say the Due Date field, Validation Rule, use the > symbo
and then the Field you want it to be greater than, Loan date. You ca
also type in what you want the pop up window to say by typing in th
Validation Text so it will remind you why the error occured.

G2

ps...
to also allow for the date it was loaned on, use the symbol >= befor
the field
 
The way I handle it is on the form design to make the Property of th
one field, say the Due Date field, Validation Rule, use the > symbo
and then the Field you want it to be greater than, Loan date. You ca
also type in what you want the pop up window to say by typing in th
Validation Text so it will remind you why the error occured.

G2

ps...
to also allow for the date it was loaned on, use the symbol >= befor
the field
 
Back
Top