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: 
greend21
Creator III
Creator III

Make Date from 3 character Month; Ex: Apr

I have a year field and a month field that shows Jan, Feb, Mar, Apr, etx. My load script also already has :

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

It is probably easy but I cannot seem to get these fields in a format such as Apr 2017. The issue is I need to create a rolling 12 month flag so I didnt think Month&' '&Year would work. Any help is appreciated.

Thank you!

1 Solution

Accepted Solutions
tresesco
MVP
MVP

If you have a year field too, try like:

Load

          MonthName(MakeDate(YearField, Month(Date#(MonthField, 'MMM'))) as MonthName

View solution in original post

3 Replies
tresesco
MVP
MVP

If you have a year field too, try like:

Load

          MonthName(MakeDate(YearField, Month(Date#(MonthField, 'MMM'))) as MonthName

Anil_Babu_Samineni

You need to do like below? MonthName(DateField) as MonthName

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sunny_talwar

Or you can try this

Date(Date#(Month&Year, 'MMMYYYY'), 'MMM YYYY') as MonthYear