3 Replies Latest reply on Sep 27, 2012 10:08 PM by comment

    Range of dates with variables

    gobbles

      Help me out of my missery please. I have no idea why this is throwing an error.

       

      I have a simple search feature that allows an end user to select a year from a dropdown list then it - should - calculate the financial year and perform a search on the range of dates associated.

       

      set variable: $year

      set variable:$lastyear: $year-1

      perform find: 1/7/$lastYear...30/6/$year

       

      This thing always throws this error: "The provided find criteria are not valid. Enter a valid find request before proceeding"

       

      If I set error capture on or just hit continue it seems to do the find just fine but the error is driving me crazy.

       

      what am I doing wrong?