Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Set Checkbox = True, if the Record's date is after Today

Topic Labels: Formulas
3223 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Greyson
6 - Interface Innovator
6 - Interface Innovator

I have a Date Field and a Checkbox Field

I would like Records with Dates in the Past to be unchecked and Dates that are equal to today or in the future to be checked.

Date Checkbox
3/16 True
3/15 True
3/14 True
3/13 False
3/12 False
3/11 False
3/10 False

Thank you

4 Replies 4
Mac
8 - Airtable Astronomer
8 - Airtable Astronomer

Probably a better way to do this but here is my 5 minute effort:

I used two formulas and a date column

diff formula: DATETIME_DIFF(Date,TODAY(), “days”)

checkbox formula: IF(Diff > -1,“ :white_check_mark: ”)

Greyson
6 - Interface Innovator
6 - Interface Innovator

@Mac Nice work, this is exactly what I needed, thank you

Mac
8 - Airtable Astronomer
8 - Airtable Astronomer

Beautiful! Glad I could help!

Curtis_Bowden
4 - Data Explorer
4 - Data Explorer

I have a similar need, but I want a checkbox column checked TRUE if a date field is after real-time TODAY.
I.e., If my “Expiration date” field is after TODAY, I want my “Active Term” Field checked true.