Comparing dates

[campelliann]

Hi there, 

I have a calculated column on PQ where I want to compare a date someone leaves the company to today, to conclude if the person is active or not. 

So I basically did if [Demission Date] = null or [Demission Date] >= Date.From(Datetimefixedlocalnow()).

And I am getting someone who leaves today 17-3 is inactive. If I extract the date from Datetimefixedlocalnow() and today is 17-3, shouldnt just be equal? [Demission Date] is date only type.

[Vijay_A_Verma · Accepted solution]

In my view, you >= should be changed to > only  as the person will be inactive from tomorrow only not today. 

= is forcing it to be equal to today. 

[campelliann]

Actually I am going to do the other way around. 
My conditions are to find active. So demission = null the person is active. if the demission date is today() or afterwards the person is also active. Something to do with the time perhaps.