I can't seem to get this to work. I have a 'status board' layout in the database where employees will enter a date (such as 12/28/2009) to indicate they have ran a report (or whatever). These are supposed to be done by a particular date (such as 12/29/2009) every month (the 21st of every month is a good example).

I'd like a calculation that will trigger when this date elapses (so they have a date of 11/28/2009 in December when 12/21/2009 rolls around indicating they haven't done this yet) so I can make this a trigger in conditional field formatting.

Is there a way to do this that I'm missing? Thank you!!

Couldn't you have a due date for the record? Then, set a condtl formatting formula if Get (CurrentDate) > DueDate and IsEmpty (DateComplete)

Edited December 29, 200916 yr by Guest

It changes monthly (or specifically, each month this action needs to be taken...for example on the 21st of each month they need to do task "x").

So maybe what I'm asking for is a due date that changes monthly based on the current date, a set due by date in each month, and if the date has been entered already (so if they already put in a date for that month, they are ok...it's only if there is a date for the prior month there is a problem)

I hope that made sense...now I'm confusing myself :

It changes monthly

I don't think it does - it should look at the date of the last report, and check if today is later than the 21st of the month following the month of the last report.

This of course requires that running a report is recorded somewhere.