Joseph31 Posted January 26, 2005 Share Posted January 26, 2005 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 Link to comment Share on other sites More sharing options...
-Queue- Posted January 26, 2005 Share Posted January 26, 2005 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. Link to comment Share on other sites More sharing options...
Joseph31 Posted January 27, 2005 Author Share Posted January 27, 2005 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 Link to comment Share on other sites More sharing options...
Joseph31 Posted February 1, 2005 Author Share Posted February 1, 2005 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 Link to comment Share on other sites More sharing options...
-Queue- Posted February 1, 2005 Share Posted February 1, 2005 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6632 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now