1st date and last date of every month in an order

Help Something Else
1

Hello Team,

Kindly help me with an solution regarding how to get 1st date and last date of every month in an order till current month ?

Thank you,

2

@Samje

check the reference

1 Like
3

@Samje ,

Use assign activity and use below code to get the dates.

Get the First Date of the Current Month:

New DateTime(DateTime.Now.Year, DateTime.Now.Month, 1)

Get the Last Date of the Current Month :slight_smile:

New DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month))

Thanks,
Ashok :slight_smile:

1 Like
4

Hi @Samje

Check the below xaml file.
Sequence11.xaml (9.1 KB)

Output:
image

Please let me know if the workflow doesn’t open.

Regards

1 Like
5

Hi Ashok,

Thank you for your reply.

Can you help me with order from January till current month 1st date and last date ?

Thanks,
Sam

6

Hi Varun,

Thank you for your reply.

It’s works.

Regards,
Sam

1 Like
7

You’re welcome @Samje

Happy Automation!!

8

Hi Varun,

Can you help me with previous year 2023 Instead of 2024 ?

Thank you,

1 Like
9

Hi @Samje

Can you raise a new query on this.

Meanwhile this is the below is the code:

Sequence11.xaml (9.6 KB)

Regards

10

@Samje ,

Here you have a code

Workflow.xaml (12.7 KB)

image
image900×880 31.9 KB

Update the for first date and last dates as per your requirement and you will have the dates in the range you want.

image
image1163×152 12.1 KB

Thanks,
Ashok :slight_smile:

1 Like
11

Hi Varun,

ok. Thank you

Regards,
Sam

1 Like
12

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