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


K

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
 
Ad

Advertisements

Ad

Advertisements

G

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]))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top