Lock date to current month

[Matt Leach]

I currently have a date field with a drop down calendar that is used as a "closed date". This indicates when a file is closed and billed. We have to close files within 30 days but some of the users are back-dating the date to fit the 30 day window.

I could take away the permission but that would create more work for our billing person.

Is it possible to lock the date field and calendar to the current month?

[bcooney]

You can either set the date field to have a validation by calculation:

Month ( datefield) & Year ( datefield) = month ( get (currentdate)) & Year ( get (currentdate))

or

Set the field to run a script that validates the date is in the proper range using a OnObjectExit script trigger (use a Exit Script (0) to cancel the entry).

[Matt Leach]

Thanks!