Extract the date

[NA_AN (Nada)]

Hello guys

I need your help

How to extract the date of the first day of the previous month and the date of the last day of the previous month?

Thank you

[rlgandu (Rajyalakshmi Gandu)]

@NA_AN

Assign firstDayOfPrevMonth = Now.AddMonths(-1).AddDays(-Now.Day + 1)
Assign lastDayOfPrevMonth = Now.AddDays(-Now.Day).AddTicks(-1)

[Yoichi]

Hi,

Can you try Modify Date activity as the following?

Regards,

[Quenton_Wayne_Rebello]

First date of previous month is New DateTime(Now.Year, Now.Month, 1).AddMonths(-1)

Last date of previous month is New DateTime(Now.Year, Now.Month, 1).AddDays(-1)

[lrtetala (Lakshman Reddy)]

Hi @NA_AN

1. Assign activity: currentDate = Now
2. Assign activity: previousMonthDate = currentDate.AddMonths(-1)
3. Assign activity: firstDayOfPreviousMonth = new DateTime(previousMonthDate.Year, previousMonthDate.Month, 1)
4. Assign activity: lastDayOfPreviousMonth = firstDayOfPreviousMonth.AddDays(-1)

[ppr (Peter Preuss)]

Have a look here:

Activities - Modify Date

AND / OR

@NA_AN

first day of the previous month

now.AddDays(-now.Day + 1).AddMonths(-1).Date

[pravallikapaluri]

Hi @NA_AN

   
   firstDayOfPrevMonth = DateTime.Now.AddMonths(-1).AddDays(-DateTime.Now.Day + 1)
   
   lastDayOfPrevMonth = DateTime.Now.AddDays(-DateTime.Now.Day).AddTicks(-1)
   

[vrdabberu (Varunraj Dabberu)]

@NA_AN

please check the below attached screenshot

Hope it helps!!

[NA_AN (Nada)]

@rlgandu

Now.AddDays(-Now.Day).AddTicks(-1)

Thank you a lot