How to get Start and End date of month by passing Month

0
Hello Team,   I am have calculated lastyear, then from lastyear date took  month as Jan-2024(See below screenshot). I want to calculate Start and End date of this particular month and same for all months till December. How can I achieve this in microflow?   Please refer below screenshot
asked
3 answers
0

Hi sideshwari,

                   use start of the month and end of the month to achieve this one

Start Date

parseDateTime('01-' + 'Jan' + '-' + formatDateTime([%CurrentDateTime%], 'yyyy'), 'dd-MMM-yyyy')

End Date

addDays(addMonths(parseDateTime('01-Jan-' + formatDateTime([%CurrentDateTime%], 'yyyy'), 'dd-MMM-yyyy'), 1), -1)

answered
0

Hi Sidheshwari,

Use the above expression but instead of giving current date and time pass your month string variable.

answered
0

Hi Sidheshwari Devkar,

 

MonthText: 'Jan-2024'

Month: parseDateTime($MonthText, 'MMM-yyyy')

StartMonth: beginOfMonth($Month)

EndMonth: endOfMonth($Month)

 

Hope this helps.

Huy

answered