Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How do i match the the name of today's date (e.g. Monday) with another field

Topic Labels: Formulas
Solved
Jump to Solution
360 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Good day, Airtable Community,
I have a base that looks like this,

image

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?

1 Solution

Accepted Solutions

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!

See Solution in Thread

1 Reply 1

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!