AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
4.1K members online now
4.1K 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