Forum Discussion

dgkallan's avatar
dgkallan
Icon for Helper II rankHelper II
2 years ago
Solved

IF two dates in the same month, but different dates

I'm working with HR data.  I will have a Run Date, which will typically be the first of the month.  Then, I will have another date, such as Termination Date in that file which could be any date (if t...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    2 years ago

    =if Date.ToText([File Run Date],"yyyyMM")=Date.ToText([Termination Date],"yyyyMM") then 1 else 0

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
2 years ago

=if Date.ToText([File Run Date],"yyyyMM")=Date.ToText([Termination Date],"yyyyMM") then 1 else 0