cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tamer66
Level: Powered On

Is it Possible to check if today in a daterange?

Hi,

 

I am looking for a possibility to check if today is in a range from 2 Dates.

 

e.g.

Start: 01.10.2019

Ende: 28.02.2020

 

Is Today between Start and End

 

I try it with <= and >= (greater as) but i guess this is not the right way.

 

thanks a lot for any idea

1 ACCEPTED SOLUTION

Accepted Solutions
SkiDK
Level 8

Re: Is it Possible to check if today in a daterange?

I don't think you're far off. You could try to check it like this:

 

If( Today() > Date(2019,10,1) && Today() < Date(2020,2,28), true, false )

 

It'll return true if today is between the two values, or return false if not.

View solution in original post

2 REPLIES 2
SkiDK
Level 8

Re: Is it Possible to check if today in a daterange?

I don't think you're far off. You could try to check it like this:

 

If( Today() > Date(2019,10,1) && Today() < Date(2020,2,28), true, false )

 

It'll return true if today is between the two values, or return false if not.

View solution in original post

Highlighted
Tamer66
Level: Powered On

Re: Is it Possible to check if today in a daterange?

Hi, that's it. Thank you very much.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 209 members 6,201 guests
Please welcome our newest community members: