Solved: Comparing dates

campelliann · ‎03-17-2023

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 · ‎03-17-2023

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.

View solution in original post

Vijay_A_Verma · ‎03-17-2023

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 · ‎03-17-2023

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.