finding date range
I'm trying to script a search for records that were created during February. The user selects a year and then runs a script which goes into find mode and sets the date field to
"2/1/" & Globals::Year & "...2/28/" & Globals::Year
This works fine for all years except a leap year where february has 29 days. During a leap year the the script would miss any records created on Feb 29th.
If I set the date field to
"2/1/" & Globals::Year & "...2/29/" & Globals::Year
Then the script will not put the date in the search field.
Is there a way to script a search for a date in february that will work for all years?