AnsweredAssumed Answered

finding date range

Question asked by jond on Sep 1, 2009
Latest reply on Sep 1, 2009 by jond

Title

finding date range

Post

Hi,

 

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?

 

Thanks

JonD

Outcomes