Logical date calculation

[noohingi]

Sorry my brain has been sent for dry cleaning. I am performing a calculation on a set of records depending on the creation date, so the fomula is simple, if(creation date >01/04/2002:x*y:0), but the resultant calculation ignores the date and applies to the all the records. What am I missing in the date format.

The creation date field is a date field and the calculation result is a number

Chris

[andygaunt]

Hi,

Your date that you are using 01/04/2002.

Can you put this inside a field (maybe a global date field) _gHoldDate

Then your calc

If(Creation Date > _gHoldDate;x*y;0)

Then it works fine.

[djgogi]

quote:

---

Originally posted by Oyseka:

Sorry my brain has been sent for dry cleaning. I am performing a calculation on a set of records depending on the creation date, so the fomula is simple, if(creation date >01/04/2002:x*y:0), but the resultant calculation ignores the date and applies to the all the records. What am I missing in the date format.

The creation date field is a date field and the calculation result is a number

Chris

---

You should use

code:

---

if(creation date>TextToDate("01/04/2002"),x*y,0)

or, use global date field instead

Dj

[ April 19, 2002, 01:16 AM: Message edited by: dj ]