How to find specific time range?

Help Studio
, ,
1

Hello,
I want to find if today’s date is between 7th and 30th of the month and if this condition is true want to write today’s date if not I want to write last day of the month.
Any advice?
Thank you.

2

image

4

HI @makboga

How about this expression?

New DateTime(Now.Year, Now.Month, Now.Day) > New DateTime(Now.Year, Now.Month, 7) And New DateTime(Now.Year, Now.Month, Now.Day) < New DateTime(Now.Year, Now.Month, 30)

Workflow Screenshot

image
image1077×358 19.7 KB

Then → DateTime.now.ToString("dd-MM-yyyy")

Else → (New DateTime(Today.AddMonths(1).Year,Today.AddMonths(1).Month,1)).AddDays(-1).toString("dd-MM-yyyy")

Output

image

Regards
Gokul

5

It is working thank you :slight_smile:

6

Mark it as Solution Bro

7

we assume that some dynamics are expected and when months do have a different end date like 31,28/29 the statement should also work

we could reformulate also the requirement:
When checkDate (e.g. Today) Day In Month < 7
Then: Today
Else: last Day of current month

So we can formulate this oneliner:
grafik
IF(now.Day < 7, now.AddDays(- now.Day + 1).AddMonths(1).AddDays(-1).Date, now.Date)

Other case test:
grafik

A february test case:

grafik
grafik698×129 23.3 KB

8

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