cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ganesan_gowri
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
GeekAlf_Pro
Resolver I
Resolver I

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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (41,633)