Help

Re: How to use date and time for conditions in scripting app

Solved
Jump to Solution
1104 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Ahsan_Tahseen
4 - Data Explorer
4 - Data Explorer

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
Ahsan_Tahseen
4 - Data Explorer
4 - Data Explorer

no need to reply anymore. ignorants

See Solution in Thread

2 Replies 2
Ahsan_Tahseen
4 - Data Explorer
4 - Data Explorer

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.