[Defect] Date/Time specifier %W is working incorrectly in 11.0

[Balders]

Instead of starting the weeks on Mondays, it is starting the week on Saturdays when using the function 'DateTimeFormat'.

[JessicaS]

Hi @Balders,

The date specifiers for week should either start the week on Sunday or Monday

%U	This will return the week number, as 00 – 53, with the beginning of weeks as Sunday.
%W	This will return the week number, as 00 – 53, with the beginning of weeks as Monday.

https://help.alteryx.com/11.0/index.htm#Reference/DateTimeFunctions.htm

Can you upload a small sample of your data and workflow that is producing this result? 

Thanks!

[Balders]

Hi Jessica,

I've uploaded an example workflow (& data) with the problem here: 

https://drive.google.com/drive/folders/0Bz7na64bIU8fejgtdEZJM2o5bzg?usp=sharing 

and here it is as seen in the final browse:

Ian

[JessicaS]

Hi @Balders,

This is a known issue we are tracking.  I'll be able to provide more of an update later this week so I'll reply back here when more information becomes available.  In the meantime, please let me know if you have any additional questions.

Thanks,

[JessicaS · Accepted solution]

Hello @Balders,

An update  (version 11.0.5.26351 ) was released this morning that includes a resolution for this issue.  You can download it from downloads.alteryx.com. If you have any questions please let me know.

Thanks,

[JessicaS]

Since this issue has been resolved, I'm going to go ahead and move this post over to the Data Preparation & Blending section for greater visibility