Formula to pull Active Employees or terminated within last 35 days

[melissa_grit]

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? 

[Ritesh_Parmar]

 Hi, can you share few sample records ?

[melissa_grit]

See attached screenshots. Thanks!

[Ritesh_Parmar · Accepted solution]

HI, this should work

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

[melissa_grit]

Thank you! This worked!