topic Re: Make Date from 3 character Month; Ex: Apr in QlikView

Make Date from 3 character Month; Ex: Apr

greend21 — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Make Date from 3 character Month; Ex: Apr

tresB — Fri, 12 Jan 2018 14:05:26 GMT

If you have a year field too, try like:

Load

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

Re: Make Date from 3 character Month; Ex: Apr

Anil_Babu_Samineni — Fri, 12 Jan 2018 14:06:30 GMT

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

Re: Make Date from 3 character Month; Ex: Apr

sunny_talwar — Fri, 12 Jan 2018 14:07:36 GMT

Or you can try this

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