February 25, 201016 yr 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?
February 25, 201015 yr 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).
Create an account or sign in to comment