topic Re: Convert specific number to date format in QlikView

Convert specific number to date format

Sat, 03 Jun 2017 17:13:45 GMT

Hi,

I have a particular dimension (called period) wich consists of a number of 4 digits: 1625. The first two (16) represents the year, and the last two represents the week of the year (25).

Is there any possible way to convert this number of four digits in a date format? So I could use date attributes like AddMonths(), AddYears() or Months()...

I'm looking for a way similar when you want to convert timestamps into date format using Date(‹number›, ‹format›), only that my initial number is not a timestamp.

Thank you for your help in advance.

Re: Convert specific number to date format

antoniotiman — Sat, 03 Jun 2017 21:34:06 GMT

May be

MakeWeekDate('20'&Left(Text(period),2),Right(Text(period),2))

Regards,

Antonio

Re: Convert specific number to date format

Sun, 04 Jun 2017 09:57:23 GMT

Thank you Antonio!

It works perfectly! Just what I was looking for.