Based on Current Date get all previous months in current and previous year

sneha_bhiwagade1

Hi,

Based on Date="2019-12-20" I was able to get all the months of the current year using generate rows formula

[ListOfMonths]>= DateTimeAdd([Date],-DateTimeMonth([Date]),"months")

But now when I am selecting Date as "2020-01-20".
Not able to get the list of all the months from previous year.

Thank You!

Date Time

Best Practices

Accepted answers

DavidP

Does this work for you?

list of months.yxmd

All comments

DavidP

Does this work for you?

list of months.yxmd

RolandSchubert

Hi @sneha_bhiwagade1 ,

if I got the right understanding, you want all previous months for previous and current year for 2019-12-20 this list would include Jan 2018 - Nov 2019, for 2020-01-20 it would be Jan-2019 - Dec 2019. I've created a sample workflow- what do you think?

Best,

Roland

MonthPrevCurrYear.yxmd

sneha_bhiwagade1

It's working perfectly fine.

Many Thanks.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703