Formula to pull Active Employees or terminated within last 35 days

Hello! I have tried the following, but I am getting terminated employees to pull through that are from old years.

[Employee Status] in ('Active', 'On-Leave') or ([Termination Date]<=Datetimeadd(DateTimeToday(),-1, 'month'))

and

[Employee Status] in ('Active', 'On-Leave') or ([Termination Date]<=Datetimeadd(DateTimeToday(),-35, 'days'))

What am I doing wrong?

Community

Accepted answers

HI, this should work

[Employee Status]="Active" or ([Employee Status]="Terminated" and DateTimeDiff(DateTimeToday(),[Termination Date],"DAYS")<36)

Hi, can you share few sample records ?

See attached screenshots. Thanks!

HI, this should work

[Employee Status]="Active" or ([Employee Status]="Terminated" and DateTimeDiff(DateTimeToday(),[Termination Date],"DAYS")<36)

Thank you! This worked!