Convert specific number to date format

[#1]

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.

[antoniotiman · Accepted solution]

May be

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

Regards,

Antonio

[#3]

Thank you Antonio!

It works perfectly! Just what I was looking for.