Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
0li5a3a
Creator III
Creator III

transform the date

Hi,

is possible to transform the date format from

42107 TO  WW-YYYY?

I don't want to create a master calendar I want to do this just for a specific column in my table.

Thanks

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

WeekName(Date) or

Week(Date)&'-'&Year(Date)

View solution in original post

7 Replies
prat1507
Specialist
Specialist

Maybe this

=date(42107 ,'WW-YYYY')

0li5a3a
Creator III
Creator III
Author

I tried already this and doesn't work in my scenario...

the date looks like 01-2017, 02-2017, 03-2017 and again 01-2017, 02-2017, 03-2017 which is wrong suppose to be

01-2017, 02-2017,03-2017, 04-2017 to 52-2017

antoniotiman
Master III
Master III

WeekName(Date) or

Week(Date)&'-'&Year(Date)

prat1507
Specialist
Specialist

Sorry

Use

=weekname(date(42094))

tyagishaila
Specialist
Specialist

=Week(date(42107 ))&'-'&Year(date(42107 ))

0li5a3a
Creator III
Creator III
Author

using WeekName(Date)   i would have this format 2017- 23.

using Week(Date)&'-'&Year(Date)  i  would have this format 1-2017 ,12016, 2-2017,2-2016 I want to have this format ww-yyyy (52-2016,01-2017,02-2017................20-2017 etc)

antoniotiman
Master III
Master III

Num(Week(Date),'00')