cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yerlasdutco
Helper I
Helper I

Show Date Periods

Hi Folks,

 

I Have an dropdown, that shows 4 last periods. 

Yerlasdutco_1-1625632168979.png

 

But, this week period needs to appear on Friday, not Monday. How can I do it?

[Concatenate( Text( Today() + 0  - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy")," - " ,Text(Today() + 6  - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy") ),
    Concatenate( Text( Today() - 7 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy")," - " ,Text(Today() - 1 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy") ),
Concatenate( Text( Today() - 14 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy")," - " ,Text(Today() - 8 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy")),
    Concatenate( Text( Today() - 21 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy")," - " ,Text(Today() - 15 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy") )
 
    ]  
1 ACCEPTED SOLUTION

Accepted Solutions
Sid_Jafri
Responsive Resident
Responsive Resident

Hi @Yerlasdutco ,

 

Please try this

[
If(Weekday(Today())=6,Concatenate( Text( Today() + 0 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy")," - " ,Text(Today() + 6 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy") )),
Concatenate( Text( Today() - 7 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy")," - " ,Text(Today() - 1 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy") ),
Concatenate( Text( Today() - 14 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy")," - " ,Text(Today() - 8 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy")),
Concatenate( Text( Today() - 21 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy")," - " ,Text(Today() - 15 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy") )

]

 

Please Thumbs up and accept as solution if my post helped you solve your issue.

View solution in original post

8 REPLIES 8
Sid_Jafri
Responsive Resident
Responsive Resident

Hi @Yerlasdutco 

 

You can simply use +4 instead of +6, wouldn't this help? this is your code. Please let me know if I didn't understand correctly.

[Concatenate( Text( Today() + 0 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy")," - " ,Text(Today() + 4 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy") ),
Concatenate( Text( Today() - 7 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy")," - " ,Text(Today() - 1 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy") ),
Concatenate( Text( Today() - 14 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy")," - " ,Text(Today() - 8 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy")),
Concatenate( Text( Today() - 21 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy")," - " ,Text(Today() - 15 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy") )
]

 

Please Thumbs up and accept as solution if my post helped you solve your issue.

+ 4 changes date of period 

Yerlasdutco_0-1625632787865.png

I need this last period appearing on Friday 09-July, not on Monday 05-July, So till Friday, nobody can access to this week period

[Concatenate( Text( Today() + 0  - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy")," - " ,Text(Today() + 6  - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy") )
WarrenBelz
Super User
Super User

Hi @Yerlasdutco ,

Do you want Friday to Friday?

WarrenBelz_0-1625633232389.png

 

[
   Text(
      Today() + 4 - Weekday(
         Today(),
         MondayZero
      ),
      "[$-en-US]dd.mm.yyyy"
   ) & " - " & Text(
      Today() + 10 - Weekday(
         Today(),
         MondayZero
      ),
      "[$-en-US]dd.mm.yyyy"
   ),
   Text(
      Today() - 3 - Weekday(
         Today(),
         MondayZero
      ),
      "[$-en-US]dd.mm.yyyy"
   ) & " - " & Text(
      Today() + 3 - Weekday(
         Today(),
         MondayZero
      ),
      "[$-en-US]dd.mm.yyyy"
   ),
   Text(
      Today() - 14 - Weekday(
         Today(),
         MondayZero
      ),
      "[$-en-US]dd.mm.yyyy"
   ) & " - " & Text(
      Today() - 8 - Weekday(
         Today(),
         MondayZero
      ),
      "[$-en-US]dd.mm.yyyy"
   ),
   Text(
      Today() - 21 - Weekday(
         Today(),
         MondayZero
      ),
      "[$-en-US]dd.mm.yyyy"
   ) & " - " & Text(
      Today() - 15 - Weekday(
         Today(),
         MondayZero
      ),
      "[$-en-US]dd.mm.yyyy"
   )
]

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

 

Sid_Jafri
Responsive Resident
Responsive Resident

Hi @Yerlasdutco ,

 

Please try this

[
If(Weekday(Today())=6,Concatenate( Text( Today() + 0 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy")," - " ,Text(Today() + 6 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy") )),
Concatenate( Text( Today() - 7 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy")," - " ,Text(Today() - 1 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy") ),
Concatenate( Text( Today() - 14 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy")," - " ,Text(Today() - 8 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy")),
Concatenate( Text( Today() - 21 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy")," - " ,Text(Today() - 15 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy") )

]

 

Please Thumbs up and accept as solution if my post helped you solve your issue.

View solution in original post

No, I need last item to appear on Friday of the week.

what does mean Weekday(Today())=6? It means Today equals to Saturday?

Now is empty 

Yerlasdutco_0-1625633839662.png

 

@Yerlasdutco 

 

Sunday = 1 and Friday will be 6 so on Friday it will be visible

 

Please Thumbs up and accept as solution if my post helped you solve your issue.

 

I know it is showing blank and you can get rid of it by using in this way. 

If(Weekday(Today())=6,
[
Concatenate( Text( Today() + 0 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy")," - " ,Text(Today() + 6 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy") ),
Concatenate( Text( Today() - 7 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy")," - " ,Text(Today() - 1 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy") ),
Concatenate( Text( Today() - 14 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy")," - " ,Text(Today() - 8 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy")),
Concatenate( Text( Today() - 21 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy")," - " ,Text(Today() - 15 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy") )

],
[
Concatenate( Text( Today() - 7 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy")," - " ,Text(Today() - 1 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy") ),
Concatenate( Text( Today() - 14 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy")," - " ,Text(Today() - 8 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy")),
Concatenate( Text( Today() - 21 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy")," - " ,Text(Today() - 15 - Weekday(Today(), MondayZero),"[$-en-US]dd.mm.yyyy") )

])

 

Please Thumbs up and accept as solution if my post helped you solve your issue.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,247)