Forum Discussion
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 that person left). I want to mark as "1" if the Termination date is in the same month as the Run Date, else a "0"
For example
| Employee | Status | Termination Date | File Run Date |
| 11111 | Inactive | 9/7/2023 | 9/1/2023 |
I want to create a custom column that would mark this as a "1" since file run date and termination date are in the same month. If termination date had been 10/7/2023, that would be a "0".
=if Date.ToText([File Run Date],"yyyyMM")=Date.ToText([Termination Date],"yyyyMM") then 1 else 0
3 Replies
=if Date.ToText([File Run Date],"yyyyMM")=Date.ToText([Termination Date],"yyyyMM") then 1 else 0
wdx223_Daniel or anyone else for that matter,
I realized one flaw in my design. I actually need to match up the File Run Date with the Termination Date for when the Termination was in the previous month. So, in easy speak (File Run Date) month - 1 month = Termination Date month
=if Date.ToText(Date.AddMonths([File Run Date],-1),"yyyyMM")=Date.ToText([Termination Date],"yyyyMM") then 1 else 0
