2 Replies Latest reply on Sep 1, 2009 7:28 PM by jond

    finding date range

    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