Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Set up a reminder column to return 0 at specific time on due date in my own time zone

Topic Labels: Formulas
328 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello, I have set up a integration of airtable and asana with integromat. Now i would like to update task in asana with a comment on the due date.

I would like to add this comment at 5 pm on the day of the due date since our office closes at 6 pm. The assignee could then reply with reason why the task was delayed.

Currently, the Due date column doesn’t keep time enabled and i would like to keep it that way. Default is 12 am i think. Now, i created the same column ‘due in’, but i want it to be in hours which become zero at 5 pm on the day of the due date.

In Integromat, i can simply filter all records where the ‘due in’ is zero or less to add a comment.

Using, Now () in formulae in returns in hours but i want it to be in my own time zone. I am using this formulae.
DATETIME_DIFF(NOW(),{Due date},‘hours’)
Please guide.

1 Reply 1