cheerfulzebra Posted September 10, 2020 Share Posted September 10, 2020 Hi All I am hoping some one can help! I have a table called TPM, in that table is a field "Next Due Date" Which is auto generated by creating a new record. You input the date you did the service and then it adds 3 months to that date and that appears in the Next Due Date Field.. All working... What I am trying to do is when the database loads it runs a script to see if there are any outstanding TPM Services to do... Here is the script Show Customer Dialog Message: If ( TPM::TPM Next Due Date < Get (CurrentDate ) ; "You have outstanding TPM services" ; "You have no outstanding services") I thought it would be that simple. So I created a TPM Due date Less that Current date and ran the script...."You have outstanding TPM Services"...GREAT! Then I deleted that record and ran the script again...""You have outstanding TPM Services" Oh!!! That isnt true! PLEASE HELP I'M LOOSING THE WILL TO LIVE HERE!!! Link to comment Share on other sites More sharing options...
This topic is 1001 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 account
Already have an account? Sign in here.Sign In Now