Im working on a calculation that references a pre-edfined date field.

The if statement i am tryin to create is:

if datefield < currentdate and > datefiled + 30

This is the exact calculation i have entered but it does not appear to work:

TechSupport::SW PD 2 > Get ( CurrentDate) and TechSupport::SW PD 2 < TechSupport::SW PD 2 + 30

To give you some background on what i am tryin to accomplish:

The date field is a maintenance date, so lets say that their maintenance expires 7/31/10. They have a 30 day grace period from the date of expiration. so i want to mark the record to show that they are in a crace period if the current date is anywhere between 8/1 and 8/31

so if the current date is greater than the maintenance date, but less than the maintenance date + 30, then i want to show the record is in a grace period.

Hope it makes sense

Edited August 5, 201015 yr by Guest

Use parentheses to ensure the calc is evaluating per your intention. But the second part doesn't make sense. X will always be less than X + 30.

(TechSupport::SW PD 2 > Get ( CurrentDate))

and

(TechSupport::SW PD 2 < TechSupport::SW PD 2 + 30)

Edited August 5, 201015 yr by Guest

Try =

Datefield < Get (CurrentDate) and Get (CurrentDate) < Datefield + 30 

My apologies, after re-reading what i had posted, the second part was supposed to read

current date < date + 30

but it now works flawlessly, thank you