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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
stekol61
Creator
Creator

Month Year format

I'm loading some data in my app  and using this expression:
v_currentMonth = Replace(monthname(today()),'-','-');
The format of the result is e.g. 'feb. 2019'

I want to have the format '2019-feb.'. How can I do this?

1 Solution

Accepted Solutions
Mauritz_SA
Partner - Specialist
Partner - Specialist

Hi there

Don't you just want to use Date(today(),'YYYY-MMM')?

Regards,

Mauritz

View solution in original post

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

v_currentMonth =Date(Today(),'YYYY-MMM');

talk is cheap, supply exceeds demand
Mauritz_SA
Partner - Specialist
Partner - Specialist

Hi there

Don't you just want to use Date(today(),'YYYY-MMM')?

Regards,

Mauritz