Getting the Month Duration

Help StudioX
,
2

Hi @Gus_Fring

Can you try with this expression

dt.AsEnumerable.Select(Function(r) String.Join(",",Enumerable.Range(0,1+CInt(DateDiff(DateInterval.Month, DateTime.Parse(r("Start Date").ToString+" 1,
New System.Globalization.CultureInfo,
DateTime.Parse(r("End Date").ToString+ 1)))).Select(Function(i) DateTime.Parse(r("Start Date").ToString+" 1,
New System.Globalization.CultureInfo).AddMonths(i).ToString("MMMM-yyyy",New System.Globalization.CultureInfo)))).ToArray

Regards
Gokul