Next month's first date in order for 2023, from January to December

[Samje (Sam)]

Hi Team,

Can you me with a solution on how to get next month’s first date in order for 2023, from January to December

Thank you,

[ppr (Peter Preuss)]

maybe you can elaborate more on your use case as it can be understood in many directions.

When interested in a series have a look here:

[muktadir]

Hi Team,
Can you me with a solution on how to get next month’s first date in order for 2023, from January to December
Thank you,

Wouldnt the next first date always be 1?

do you mean the first working day or date of the month?

[Parvathy (PS Parvathy)]

Hi @Samje

Check the below thread:
Sequence11.xaml (9.5 KB)

Hope it helps!!

[Samje (Sam)]

Hi Muktadir,

For example, If it is January month - 01-02-2023, February - 01-03-2023, March - 01-04-2023… Like this.

Thank you,

[ppr (Peter Preuss)]

@Samje

If it is January month - 01-02-2023, February - 01-03-2023

we can set an offset on the series creation

[ppr (Peter Preuss)]

As an alternate - a lookup dictionary

[avejr748 (Ave Salvante Jr)]

Or just assign to strNextMonthFirstDay = “01-” & Date.Now.AddMonths(1).ToString(“MM”) & “-” & Date.Now.AddYears(-1).ToString(“yyyy”)

If you need this for the currentyear then just remove the AddYears