Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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')