Skip to main content
Question

Create a formula for date time field

  • December 18, 2019
  • 0 replies
  • 84 views
I have a field called 'Check Out Time' which is a date time field. I want to check in a formula field, if current time is greater than the check out time or not. 
If the current time is greater than check out time then a status field needs to change a value from the drop down. 

How do I create a formula to compare date time fields with now function? I keep getting errors.

------------------------------
Raj Helaiya
------------------------------

Forum|alt.badge.img+15
  • DonLarson
  • Qrew Cadet
  • December 18, 2019
Raj,

Create a Formula Check Box, for example the new field is Check Out Time Is In Future

If ( [Check Out Time]>Now(), True, False)

Now you can use that field to drive reports.   Getting it to change a status is a little more tricky.

When the value goes to False, you will be past the Check Out Time and a workflow needs to kick off.   

The human powered answer is to put a report on the dashboard of the person who is supposed to monitor and change status of the business object.   You can add to the filter for the report a line on the status so if the report is empty, then they have done their job.

Doing it automatically is better but requires some outside tools.   Automations in Quick Base require a human to do something:




However Juiced Technology www.juicedtech.com sells a tool called Triggers.  It has a Scheduled Trigger function that lets you check the data for changes and then kick off the changes you need.  I heartily recommend their product.  i have customers with hundreds of Triggers in single applications to automate lots of status changes and other processes.




------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Terms & ConditionsAccessibility statement