Forum Discussion

RajHelaiya's avatar
RajHelaiya
Qrew Captain
6 years ago

Create a formula for date time field

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
------------------------------
Formulas and functions
  • DonLarson's avatar
    DonLarson
    Qrew Elite
    6 years ago
    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
    ------------------------------