Range of dates with variables

Discussion created by gobbles on Sep 27, 2012
Latest reply on Sep 27, 2012 by comment

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?