Makeing a Auto Reminder Field?

[Joseph31]

Hello everybody,

Is it possiable to make a calc that looks at a fields date of modification and when it is over 30 days from current date it will flag it for reminder either by popup mesage and or by appearence on a portal?

Joseph

[-Queue-]

Get(CurrentDate) - DateModification > 30

As an unstored number calculation, this will return 1 when true. It can't be used as a key for a child relationship, but you can perform a find for 1 in it to retrieve an up-to-date record set or format it as a yes/no field in a portal or on an individual record layout.

[Joseph31]

Oh, Cool thanks...

That might do it... If you know anything else that is cool for like say a self checking data base for lets say reoccuring bills let me know.

Joseph

[Joseph31]

I keep trying to do a find for #1 but I am having no luck with that... also How do you make it a yes or no for a portal? Not sure how do do that...

Joseph

[-Queue-]

The calculation must be unstored, with a number result. If it is, you should have no trouble searching for 1.

I don't understand your portal question. Do you mean like a filter? There are plenty of threads regarding portal filtering here. Search for them.