Validation of a field

[admoortown]

Hi, i have a system that allows users to enter receipts for different goods.

 

the user enters the date and the certain values for each receipt. I also have a list of the previous receipts and their dates stored in a portal. but i want to validate the date field so that when they enter a new receipt and enter a date into the date field that the date cannot be less than the last date entered, and if they do a window would appear stating this.

 

Hope this makes sense and any help would be greatly appreciated.

[aaa]

Hi, admoortown!

Validate your Date>=Max_Date, where Max_Date is summary field with Maximum of Date.

[Colin Weir]

Under options for field: check validate by calculation:specify and enter your calculation.

 

Check Display custom message if validation fails and enter a meaningful message.

 

Incidently I was doing something on this today. Are there any ways of giving user choices in a window (when a validation fails by calculation) in the same way as a script can using custom dialogues?