Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be
MakeWeekDate('20'&Left(Text(period),2),Right(Text(period),2))
Regards,
Antonio
May be
MakeWeekDate('20'&Left(Text(period),2),Right(Text(period),2))
Regards,
Antonio
Thank you Antonio!
It works perfectly! Just what I was looking for.