In need to test if a task has happened in six month increments...

[Kelvin Beaton]

I'm working on a tasks due list and need an entry to show up if task has not
yet happened in current (or past period) 30 day period.
I have clients that have an effective date (start date).
The case manager needs to submit a report for each 30 day period from the
effective date.

I believe this statement will tell me if it happened in the first 30 days
and calculates 30 days from when the task last took place. But I think the
logic of calculating it off when it was last done will run into trouble if
the do it late then the follwoing ones will be late. I believe I need to
measure off the start date to be consistant with the 30 day increments...

PeriodicReviewReportDue:
IIf(DateDiff("d",Now(),[MaxOfDateFF]>=30),DateAdd("d",30,[MaxOfDateFF]),DateAdd("d",30,[CaseNotification-EffectiveDateC]))

Can someone help me out or point me in the right direction?

Thanks in advance!!!

Kelvin

 

[Kelvin Beaton]

I should have change the title to be 30 days... sorry

Kelvin

 

[Guest]

A couple of questions and observations.
What is the field name of the effective date (start date)?
You did not close the function - - DateDiff("d",Now(),[MaxOfDateFF]
There needs to be a closing parenthesis before starting the evaluation.

PeriodicReviewReportDue:
IIf(DateDiff("d",Now(),[MaxOfDateFF])>=30,DateAdd("d",30,[MaxOfDateFF]),DateAdd("d",30,[CaseNotification-EffectiveDateC]))