Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
stekol61
Creator
Creator

Week format

I'm loading data in my app and is using this expression:
v_previousWeek = Replace(weekname(today(1)-7),'/','-');
The result is e.g. '2019-09'

I want to have the format as '2019-9' instead. How can this be done?

1 Solution

Accepted Solutions
Shubham_Deshmukh
Specialist
Specialist

v_previousWeek=year(today())&'-'&Week(today())

View solution in original post

1 Reply
Shubham_Deshmukh
Specialist
Specialist

v_previousWeek=year(today())&'-'&Week(today())