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
Regular Visitor

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

Anonymous
Not applicable

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 😉

Anonymous
Not applicable

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

Advocate IV

bump! update please.