cancel
Showing results for 
Search instead for 
Did you mean: 

Addition of Week Number function in Powerapps

Currently, we don't have any direct way to calculate week number of the particular Date.

It would be better to have a function which displays the weeknumber for example: WeekNum("26-10-2017") = 43 to avoid usage of other source for this information and then retrieving back to Powerapps application.

 

Status: Under Review

Updating status and adding @GregLi

Comments
Level: Powered On

Please please please - dont forget the Europeans - the weekno in ISO is different from the weekno used in USA 
ISO: weekno: There are no splitted week-numbers across the year-change so 1.1.nnnn can be weekno 53 (of the year before) and the ISO week starts on mondays !!!

mfg Klaus Obd

Level: Powered On

This formula is working for me (in powerapps, there is another one for Sharepoint lists:

 

If(DateValue1_1.SelectedDate>0;RoundUp((DatePicker1.SelectedDate-DatePicker1_1.SelectedDate)/7;0)-RoundUp((DatePicker1.SelectedDate-DateValue1_1.SelectedDate)/7;0)+1;"")

 

DateValue1_1= The date I want to know the Weeknum of.

DatePicker1=Date selector control with the date 12/31/2018

DatePicker1_1=Date selector control with the date 01/01/2018

 

It works only when the week starts on Monday, which is my case Smiley Wink

Anonymous
Not applicable

It has been more thank a year since this idea was voted . Is there any news ???