Compare date column with fixed date

Platform discussions
1

Hi,
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:

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

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
Luigi

2

Try this:

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

1 Like
3

Thanks @JCorrell! The workaround works!

4

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