Data Studio
4.9K members online now
4.9K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

TODATE for Week ISO in Data Studio Broken?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Picture says it all. Works fine converting to %Y%m.

But plain broken converting to %Y%W.

Surely Im missing something?

 

DS Horror.png

TODATE for Week ISO in Data Studio Broken?

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Hi, did you manage to find a workaround ?

 

When I use TODATE(Date, '%Y-%W') Data Studio takes '%W' as the day of the week:

 

...

2014-Saturday
2014-Sunday
2014-Thursday

...

Using '%w' gives:

 

2014-05
2014-06
2014-04

...

 

Best regards,

 

Output formats

TODATE accepts the following output format strings:

  • "%Y" - year
  • "%m" - month
  • "%d" - day
  • "%W" - yearweek number
  • "%w" - day of week
  • "%H" - hour
  • "%M" - minute