Extended date calculation

[tsbpme]

I need to create a calculation that will notify me every 90 days that a notification letter needs to go out. I will have the open date of a case but I don't know how to make it calculate and notify me every time the 90 day timeline comes up.

[LiveOak]

Your actual requirement is probably a little more complex. What if the 90th day comes on a Saturday when the database isn't opened? By Monday, it's the 92nd day and the flag is no longer set. The calculation to detect a 90 day interval is easy enough:

Ntimes90Flag (calculation, number) = not Mod(Status(CurrentDate) - open date, 90)

But, it probably isn't exactly what you want.

-bd

[kenneth2k1]

What do you guys think about a scripted setup where you have two fields?

Open Date

LastPDate (Last letter print date)

Make a script to set LastPDate to Date_NewRec

Then manually perform this find on LastPDate

<=//-90

Then make this script:

Set error capture (on)

Perform Find (Restore)

If [status(CurrentFoundCount) = 0]

Exit Script

Else

Set Field ["LastPDate", "Status(CurrentDate)]

Go to Layout [90 day letter layout]

Enter Preview Mode

Print [ ]

Go to Layout [original]

Enter Browse Mode

Show All Records

Show all records and you can perform this script. I haven't tested this or thought it completely through, so forgive me if I left something out. You could even make this script run at startup to make the process easy.

Ken