topic Re: create date with makedate function in QlikView

create date with makedate function

prma7799 — Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

How to create date with make date function

I have field months like

April

May

June

July

Aug

Sept

Oct

Nov

Dec

Jan

Feb

Mar

excepted output

01-04-2015

01-05-2015

01-06-2015

01-07-2015

01-08-2015

01-09-2015

01-10-2015

01-11-2015

01-12-2015

01-01-2016

01-02-2016

01-03-2016

Thanks

Re: create date with makedate function

rajeshforqlikvi — Mon, 11 Jan 2016 12:09:35 GMT

Returns a date calculated from the year YYYY, the month MM and the day DD.

If no month is stated, 1(January) is assumed.

If no day is stated, 1 (the 1:st) is assumed.

Ex:

makedate( 2016, 2, 14 )

returns

2016-02-14

Re: create date with makedate function

swuehl — Mon, 11 Jan 2016 12:12:28 GMT

There are multiple possible solutions, e.g. try something like

MAP:

MAPPING LOAD

Month, Makedate(2015+offset,MonthNum)

INLINE [

Month, MonthNum, offset

April, 4,0

May,5,0

June,6,0

July,7,0

Aug,8,0

Sept,9,0

Oct,10,0

Nov,11,0

Dec,12,0

Jan,1,1

Feb,2,1

Mar,3,1

];

LOAD

ApplyMap('MAP', YourMonthField, 'No Mapping found') as MonthFieldNew,

...

FROM ...;

Re: create date with makedate function

rajeshforqlikvi — Mon, 11 Jan 2016 12:13:29 GMT

Makedate(2015,4,1);

Makedate(2015,5,1)

like this you can create all dates ....

Re: create date with makedate function

prma7799 — Tue, 12 Jan 2016 05:30:33 GMT

Hi swuehl‌,

I tried your solution but I am getting date field without months.

see below,

Also find script.

Re: create date with makedate function

sunny_talwar — Tue, 12 Jan 2016 05:35:22 GMT

Try this:

Date(ApplyMap('MAP', Month, 'No Mapping found') ,'dd-MM-yyyy') as t

mm is for minutes and MM is for Months

Re: create date with makedate function

prma7799 — Tue, 12 Jan 2016 05:49:51 GMT

Hi sunindia‌,

Now am getting date field in my target fields can we link these to the master calendar

Please look into this how to add excel file into existing data model

Re: create date with makedate function

tamilarasu — Tue, 12 Jan 2016 05:54:23 GMT

Or simply try,

MakeDate(2015,Month(Date#(Left(Month,3),'MMM'))) as Date