Compare date column with fixed date

I’m trying to compare the birthday date in a date column with a fixed date to determine which generation the employee belongs to. I’m using (just a simplified example I’m using to debug the issue) a formula like this:


but it returns only “Other”. I’m sure I’m missing something very stupid and simple but can’t figure out what it is. Is there anyone who could give me a hint?

Thanks in advance

Try this:

IF((DAYS({birthDate},DATE(1985,12,31))) > 0,“GenZ”,“Other”)

1 Like

Thanks @JCorrell! The workaround works!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.