Date of next quarter month first day

Help Studio
, , , , , , ,
1

How can we get the 1st day of next quarter month?

Example
At the moment its Oct

So it should give 01/01/2023
MM/DD/YYYY

2

Hi @anmita

Check out this thread

Regards
gokul

3

HI,

Can you try the following expression?

New DateTime(Today.Year-Cint(Today.Month>=10),{0,4,4,4,7,7,7,10,10,10,1,1,1}(Today.Month),1).ToString("MM/dd/yyyy")

Regards,

4

Hello @anmita

You can use the Modify Date activity to achieve the same.

Thanks

5

Hello @anmita How about the below one

New DateTime(Now.AddMonths(3).Year,Now.AddMonths(3).Month,1).ToString("dd/MM/yyyy")

image

6

Hi @anmita ,
I am sending you a sample workflow which will help you to get the most accurate output. Please go through it I hope you get your desired output.
Main.xaml (13.1 KB)

Output Screenshot:
image

Thanks & Regards,
Shubham Dutta

7

Hi @anmita ,

Did you want this as output :

image
image741×582 25.5 KB

Also check out below code :
DateQuarter.zip (1.4 KB)

Regards,
Dibyaprakash

Mark it as solution if it resolves your issue.

8

Thanks Everyone for your quick responses:)

9

Hi @ushu,

This will not work for each month.

For example :
Input : 11/25/2022
Outoup : 02/01/2023

Above one will be output from your code.

Regards,

10

Hi @anmita,

You can mark solution which one resolved your issue, so that others can be helpful.

11

Hi @anmita ,
The solution you marked won’t give correct answers in all scenarios.
It will misguide other users who will fetch for similar problem’s solution.
Please go through my solution as well as all others too and then mark the correct solution.

Thanks & Regards,
Shubham Dutta

12

This solution will not work for november.
You can check it using a date from november month.

13

Thanks @Shubham_Dutta

1 Like