December 13, 200223 yr Hi, I have 2 global date fields, MinDate and MaxDate, that I'd like to leave empty when my script is done. I'm using Clear [select,"MinDate"] <-- Select entire contents option is checked But they are never cleared. Trying to set them to "" doesn't work either. What am I doing wrong. Thanks for any help, Dan
December 14, 200223 yr Instead use: SetField(MinDate,TextToDate("")) It converts the null value into a date equivalent.
December 14, 200223 yr The Clear command only works if the field is on the current layout when you perform the script. Also, the field has to be formatted to allow entry. Steve's solution using a Set Field command is the reliable way to do it.
Create an account or sign in to comment