cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

DatePicker

Hai ,

 

I have a Meeting_Datepicker , I Would ideally like it to default to choose the date for upcoming Tuesday Meeting. 

As followed by the above requirements : I used this Formula. Its works fine.

                        Today()+(8-Weekday(Today(), StartOfWeek.Tuesday))

 

* I have to add a little bit Logic into that, Now the date picker showing only the Upcoming Tuesday Dates.

 

For Example: 

        Now,  If  I am in the  Tuesday date - 13.10.2020 means I want to stay on the present Tuesday date(i.e, 13.10.2020) up to the next day . If Wednesday falls it wants to change automatically by calculating the upcoming Tuesday date(20.10.2020) followed by the same logic..

 

How should I apply this logic in to this formula:

                   Today()+(8-Weekday(Today(), StartOfWeek.Tuesday))

 

Thanks.

1 REPLY 1
Highlighted
Helper III
Helper III

Hi @ganesan_gowri 

 

maybe an if statement : 

 

If(
Today() + (8 - Weekday(
    Today();
    StartOfWeek.Tuesday
))= 2
;Today()
;Today() + (8 - Weekday(
    Today();
    StartOfWeek.Tuesday
))
)

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (5,131)