Current month minus 18 months

Help Studio
1

How to get current month minus 18 months i.e for example this is November2023 and I want to get May 2022 as output. and input should be first day of that month

2

@Sneha_1992

Syntax : now.AddMonths(-18).Month

Cheers!

3

Hi @Sneha_1992

currentDate: DateTime.Now
date18MonthsAgo : currentDate.AddMonths(-18)
firstDayOfPreviousMonth: new DateTime(date18MonthsAgo.Year, date18MonthsAgo.Month, 1)
Message Box: "First day of the month 18 months ago: " + firstDayOfPreviousMonth.ToString("MMMM, yyyyy")

currentDate, date18MonthsAgo, firstDayOfPreviousMonth is of datatype System.DateTime
Hope it helps!!

4

Hi @Sneha_1992

Try this

formattedDate = Now.AddMonths(-18).ToString("yyyy-MM-dd")

Hope this helps!!

5

@Sneha_1992

StartDate of type DateTime

StartDate =DateSerial(Now.AddMonths(-18).Year, Now.AddMonths(-18).Month, 1)

Hope this will help you

6 
now.AddMonths(-18).ToString("MMM yyyy")

gives you the month with year

new datetime(now.AddMonths(-18).Year,now.AddMonths(-18).Month,1).ToString("dd/MM/yyyy")

gives you the date
image

1 Like
7

Hi @Sneha_1992

Refer this workflow for better understanding:

image
image1010×727 26.6 KB

Sequence.xaml (7.3 KB)

Hope it helps!!

8

@Sneha_1992

Now.AddMonths(-18).ToString("yyyy-MM-dd")

image
image820×262 12.9 KB

Now.AddMonths(-18).ToString("MMMM yyyy")

image
image825×258 13.1 KB

9

grafik

YourDateTimeVar.AddDays(- (NowYourDateTimeVarDay - 1)).AddMonths(-18)

ADDED: When Time part needs to be 00:00:00 handling:
grafik

10

Thanks @Shiva_Nikhil

Same llike this how to get last day of the month of 18 months ago month.

1 Like
11

@Sneha_1992

new datetime(now.AddMonths(-18).Year,now.AddMonths(-18).Month,1).AddDays(-1).ToString("dd/MM/yyyy")

use this to get last day of the month which is 18 months ago