Jump to content

Conditional Formatting after date change


This topic is 3198 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I am busy creating a system where documentation needs to be collected before an application can be made for a loan. User phones client, creates client profile, then I need it to create conditional formatting after 3 days has passed to remind user to contact client and request outstanding documents. Cannot get conditional formatting to appear after 3 days.

Link to comment
Share on other sites

Cannot get conditional formatting to appear after 3 days.

​Well, thanks for letting us know. ;)

Assuming you are actually asking how to do this: try something along the lines of

Get ( CurrentDate ) > YourTable::fieldWithDateOfFirstClientContact + 3

or, if you have a creation timestamp field,

Get ( CurrentDate ) > GetAsDate ( YourTable::TSCreation ) + 3

 

Link to comment
Share on other sites

This topic is 3198 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

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.