topic Re: Convert Date to Month and Year in QlikView

Convert Date to Month and Year

Wed, 25 Nov 2020 16:16:04 GMT

I have date column with Date format as 01-01-2017.I want to get the month and Year out of this and I tried Month(Datefield) ,Year(Datefield) but it is not working.Can anyone help me here ?

Re: Convert Date to Month and Year

Mon, 08 Aug 2016 18:00:10 GMT

Hello,

Try as below:

Month(Date#(Datefield, 'DD-MM-YYYY'))

Year(Date#(Datefield, 'DD-MM-YYYY'))

BR,

Kuba

Re: Convert Date to Month and Year

vishsaggi — Mon, 08 Aug 2016 18:01:53 GMT

Try this :

= Month(Date#('01-01-2017', 'DD-MM-YYYY'))

= Year(Date#('01-01-2017', 'DD-MM-YYYY'))

Re: Convert Date to Month and Year

sunny_talwar — Mon, 08 Aug 2016 18:08:16 GMT

You can also read about Dates here:

Get the Dates Right

Why don’t my dates work?

Re: Convert Date to Month and Year

Alex-Kayanga — Wed, 16 Oct 2019 19:57:25 GMT

date(MonthStart(date(["YOUR DATA FILED NAME"],'YYYY/MM/DD')),'MMM-YYYY')

Re: Convert Date to Month and Year

shamiul_islam — Thu, 17 Oct 2019 04:31:51 GMT

If you need the Month and Year simultaneously in your file you can create Day,Month,Year separately in your script like this:

LET vToday=num(today());
LET vMinDate=42370;
LET vMaxDate=num(today());

// Temporary Table

TempCal:
LOAD
date($(vMinDate) +RowNo()) as TempDate
AutoGenerate
$(vMaxDate)-$(vMinDate);

//******************** MASTER CALENDAR**********************
MasterCalendar:

LOAD
TempDate as TRDate,

Year(TempDate) AS Year,
Month(TempDate) as Month,
day(TempDate) as MDay,
Week(TempDate) as Week,
WeekName(TempDate) as WeekName,
Date(MonthStart(TempDate),'YYYYMM') as YearMonth
Resident TempCal;

DROP Table TempCal;

Thanks.