Hi, a brief explanation of how it works -
Date() - Will convert 3 numbers to a date (YYYY,MM,DD)
to get the MM we used tonumber(left("4/1",instr("4/1","/")-1))
The tonumber converts the text string into a number which is useable within the Date funtion.
The month in your string is everything before the "/" so we do a left to trim the field to the number of characters required.
The Instr calculates the number of characters we need in our left by searching the string for "/" - ie instr("4/1","/") would return 2 as the "/" is the 2nd character - we do the -1 as we need everything before the "/".
We do the same for the DD using right and len instead of left.
Try these formulas instead;
Inside Range
currentdate >= {seasonalfrom} and currentdate <= {seasonalto}
Outside Range
currentdate < {seasonalfrom} or currentdate > {seasonalto}
Regards,
Ryan.
Edited by rkrowland - 10 Jan 2012 at 1:25am
IP Logged
