Display current and previous month in current year

[rizwanmgm]

Dear Experts,

I want to show current and previous months for current year in dropdownlist, i try the below formula but it is showing 12 months

ForAll(Sequence(13),Text(DateAdd(Today(),-Value+1,Months),"[$-en-US]mm"))

Thanks

[timl · Accepted solution]

Hi @rizwanmgm 

This should return what you're looking for by returning the dropdown values 1-4.

Filter(ForAll(Sequence(12),Text(Date(Year(Now()), Value, 01),"[$-en-US]mm")),
       Value(Value) <= Month(Now())
)

This will show the 3 character month name instead:

Filter(ForAll(Sequence(12),Text(Date(Year(Now()), Value, 01),"[$-en-US]mmm")),
       Value(Value) <= Month(Now())
)

[rizwanmgm]

Thanks a lot

[rizwanmgm]

Dear Expert,

I have a variable which gets the months as below

Set(varMonths,
Filter(ForAll(Sequence(12),Text(Date(Year(Now()), Value, 01),"[$-en-US]mm")),
Value(Value) <= Month(Now())
)
);

I bind the variable to dropdownlist items, how to show the months in for ex January, 01 format in dropdown list.

Thanks