Convert week (yyyy_wk) from string to date format

Question & Answer
, ,
1

Hello everyone,

I’m new to QuickSight and I’m looking for ideas/solutions on how to convert the string “yyyy_wk” to date format.
For example, I have “2023_44,” and the desired output could be “yyyy-MM-dd,” in this case, “2023-10-30.”

Any help would be greatly appreciated!

2

Hi @Evgeny ,

Start here and see if your string can be converted on the dataset.

If not, you’ll need to do some string manipulation to convert it, since that format isn’t supported out of the box.

You’ll use the parseDate() function (here) along with one of the string functions.

Here’s a link with supported date formats. Along with parseDate(), it’s extensive, but I don’t see yours.

I’ve not seen that format before, where is it from? How does 44 translate to 10/30?

Hope that helps.

ws