Formula to compare two dates

Ask the Community Formulas
#1

Hello SB community,
I want to create a column that shows if another column is earlier than some day (ie. 17/7/2022). How I will do?

I used DATE_DIFF in my stack but not that much effective!

Thanks :slight_smile:

#2

You can use this formula

IF({Date1}<{Date2},"Date1","Date2")