Good day, Airtable Community,
I have a base that looks like this,
And I would like to create a formula that displays true (or 1) if that day is today, so if today is Monday, all the fields that contain Monday will be 1. But I cannot find any way to do this with the Today() and other date functions. I strongly believe I am missing something.
Can anyone shed some light on this?
Best answer by augmented
Hi William. You want DATETIME_FORMAT with ‘dddd’ as the format string. Then just use the IF statement to see if {DayName} is equivalent. Cheers!
+18Hi William. You want DATETIME_FORMAT with ‘dddd’ as the format string. Then just use the IF statement to see if {DayName} is equivalent. Cheers!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
