Try something like:
Input:
Load
EMP,
Date#(DOJ,'MM/DD/YYYY') as DOJ,
Date#(DOL,'MM/DD/YYYY') as DOL
Inline [
EMP, DOJ, DOL
3359, 12/1/2015, 12/3/2016
3501, 1/1/2017, NA
A210, 8/26/2016, NA
];
NoConcatenate
FM:
//First broken month
Load
EMP,
DOJ,
DOL,
Date(If(Day(DOJ)=1, DOL,Date(DOJ+IterNo()-1))) as CalDate
Resident Input While if(Day(DOJ)=1,IterNo()=1,DOJ+IterNo()-1<=RangeMin(MonthEnd(DOJ),DOL));
LM:
//Last broken month
Load
EMP,
DOJ,
DOL,
Date(MonthStart(DOL)+IterNo()-1) as CalDate
Resident Input While MonthStart(DOL)+IterNo()-1<=DOL;
CM:
//Complete Months
Load
EMP,
DOJ,
DOL,
MonthEnd(Addmonths(DOJ,IterNo()-1)) as CalDate
Resident Input While MonthEnd(Alt(DOL,today()))>=MonthEnd(AddMonths(DOJ,iterno()-1));
Drop Table Input;
Note: Try to grasp the idea of the code instead of just copy-pasting it, so that if it needs a small adjustment in your context you can do it (I write so, because I guess that you would need to tweak a bit after rigorous testing on output. No pun intended.)
