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.

How to use date and time for conditions in scripting app

Topic Labels: Scripting extentions
Jump to Solution
338 2
Showing results for 
Search instead for 
Did you mean: 

Hi so i have a airtable table and it has date and time field. I wanted to use those value for time for calculation condition and date for comparison basically i want if else based on date and time values. How can i use that? i used JavaScript functions for that but still i cannot get my desired output. Please someone help me out here. IT IS VERY URGENT pls.

1 Solution

Accepted Solutions

no need to reply anymore. ignorants

See Solution in Thread

2 Replies 2

no need to reply anymore. ignorants

Don’t overcomplicate this and forget about the Scripting block, because Airtable’s formulas are perfect for your use case and take a fraction of a time to set up. You don’t even have to use VALUE() to do things manually given the existence of datetime_parse, datetime_diff, fromnow, tonow, etc.

JavaScript itself has nothing that comes close to Airtable’s (JS-powered) datation library that formula fields are by now.

no need to reply anymore. ignorants

Lol, I guess the world kept turning in spite of one vague and hastily written post on a productivity software board, go figure.