SET VAR viflt = (IFLT(.dtl,.#DATE,7.65,5.65)) you have dtl not dt1 (Letter L instead of number 1)
Bernie Lis ----- Original Message ----- From: mike epstein sony viao office To: RBASE-L Mailing List Sent: Monday, May 09, 2011 4:33 PM 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
