How can I convert a week number to an actual date?

Reply
Highlighted
Orange Belt

How can I convert a week number to an actual date?

This is more of a solution to a question I had.

 

To start, I'll tell you what I'm working with. I have a string which is my week number named `Week` and it looks like this:

 

  • Week 1
  • Week 2
  • Week 3

I also have an integer of the four digit year (e.g. 2016) named `Year`.

 

From these I wanted to create a date recognized within Domo as a date. I built this within a Beastmode, but the code applies to SQL very closely:

 

(

 CASE

  WHEN `Year` = 2016

          THEN STR_TO_DATE(CONCAT('2016,',TRIM(RIGHT(`Week`,2)),',Sunday'),'%Y,%U,%W')

 END

)

 

The String to Date function does the converstion of a string with a known or specified format into a date. The Concat puts the string elements together. Trim removes the white space and Right takes the specified rightmost characters.  The Sunday in the code specifies that for my circumstance I want the date that begins with Sunday.

 

If your year was a string instead of an integer like mine the above code could be further simplified. 

 

I hope this helps you out!

 

*Edit for typos

Announcements
Win free lodging at Domopalooza! We want to hear your Domo story, enter our Dojo contest and win up to four nights lodging at Domopalooza. Click here!