Last 5 days of current month

MLT · April 14, 2021, 3:32pm

Hi,

Can anyone help me how to get last 5 days of current month.

for ex: i need to get 25 th to 30 th of every month

Please help.
Thanks

Mikolaj_Zielinski · April 14, 2021, 3:38pm

Hey use this

Pravin_Patil1 · April 14, 2021, 3:40pm

Last Day : DateTime.DaysInMonth(Datetime.Now.Year, Datetime.now.Month)

5th Day from Last : (DateTime.DaysInMonth(Datetime.Now.Year, Datetime.now.Month) -5)

ppr · April 14, 2021, 5:19pm

it looks like you are interested in a series/Collection of the last 5 days fro current month (so e.g. in Feb: 24,25,26,27,28)

Variables:

Assign:
grafik

Enumerable.Range(-4,5).Select(Function (x) LastMonthDate.AddDays(x)).toList

Result:

MLT · April 15, 2021, 4:09am

Thanks @ppr its perfect

sandeep.tech2009 · April 16, 2021, 8:39am

Hi Peter,

Could we also get days 'name ’ (Sun,Mon,Tue) somehow?

Thanks!

ppr · April 16, 2021, 8:45am

we can do it within an second statement on the retrived dates. Feel free to open a new topic on your case

sandeep.tech2009 · April 16, 2021, 8:49am

I got it. Thanks

system · April 19, 2021, 8:50am

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.