An advance notification for a due report

[RAW32]

Hello my fellow tech mates,

I need to know the proper script for getting a message box to display six weeks in advance to let the user know that a report is due soon. I tried this script:

If [Interim Report1_Due_Date - Today < 42]
Show Message [This report is due soon!]
End If


This particular script does not produce the desired result. Any help would be greatly appreciated. Thanks.


RAW32

 

[Schlogg]

It always helps if you are specific - in what way doesn't it produce the desired result?
Are you sure your date fields are defined correctly?


Cheers,
Paul J.

 

[RAW32]

When I enter certain dates that are well within the range of the limit that I specified (< 42), the message does not display at all. I have also experienced the problem where the message would show up regardless of whether the days fell within the range or not. I appreciate your reply.

Raw32

 

[Schlogg]

Are you using 4-digit years on data entry? FMP does a really rotten job of handling dates with only 2-digit years.


Cheers,
Paul J.

 

[RAW32]

No, I am only using 2 characters in the year field, but I will try 4. Thanks.

RAW32