Trace it. You have a typo! Problem jumps at you . try SET VAR viflt = (IFLT(.dt1,.#DATE,7.65,5.65))
Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of mike epstein sony viao office Sent: Monday, May 09, 2011 3:33 PM To: RBASE-L Mailing List Subject: [RBASE-L] - iflt Good afternoon Can anyone tell me where I have screwed up I am trying to use a IFLT function and can't get the result I am looking for I thought that this function would return 7.65 if .dtl was less than today's date and 5.65 if it was greater than today's date. SET VAR dt1 DATE = 3/2/11 SET VAR viflt CURRENCY SET VAR viflt = (IFLT(.dtl,.#DATE,7.65,5.65)) RETURN Mike Epstein
