Skip to main content

Hi team,


Here’s the context

2 fields:

Scheduled date: A Date field with ISO format, 24h format, it includes Time and uses GMT for all collaborators


Date validation: A formula field that runs the following code:


IF(

  AND(

    {Scheduled date},

    NOW() >= {Scheduled date}

  ),

  "Ready", "In Review"

)

Problem:

When Scheduled date = Today, the formula returns Ready, ignoring the time.


For instance:

Case A



  • Scheduled date = 2022-08-23 18:00 GMT

  • NOW() = 2022-08-23 19:00 GMT


The formula returns Ready ❌


Case B



  • Scheduled date = 2022-08-24 18:00 GMT

  • NOW() = 2022-08-23 19:00 GMT


The formula returns In Review ✅


Could it be that NOW() doesn’t care about time? or is it using a different Time Zone?

Not sure what’s going on but NOW() does evaluate the time. See hereNOW() reference


I run a few tests. It works fine when Scheduled Date is a field in the same table.


In my case Scheduled Date is a linked field from a Time Slots table. When I set the linked field to a future date it immediately evaluates to true/Ready :man_shrugging:t4:

Solved!


Problem was the linked date field from another table, Scheduled Date, did not bring with it its format (ISO, GMT, include time…) so I needed to add a lookup field with the date and it worked!


Reply


Terms & Conditions