topic Re: Issue with MakeDate function in QlikView

Issue with MakeDate function

riyazasma1009 — Thu, 12 May 2016 12:38:19 GMT

Hi All,

I am using MakeDate() function as present in the below script:

Tab1:
LOAD *,
Second(Time) as TimeSec,
Minute(Time) as TimeMin,
Hour(Time) as TimeHour,
date(MakeDate(Day,Month,Year),'DD-MM-YYYY') as MakeDateTemp,

LOAD * INLINE [
ID, Time, Date, Day, Month, Year
1, 09:45, 19-03-2016, 20, 05, 1990
2, 12:32:50, 10-05-2016, 10, 10, 2000
3, 04:55:55, 04-04-2015, 20, 12, 2012
4, 01:23:45, 22-09-2015, 15, 05, 2013
5, 06:07:32, 26-05-2015, 21, 01, 1995
6, 05:04:56, 24-07-2015, 30, 08, 2015
7, 03:45:55, 09-10-2015, 27, 09, 2014
8, 10:10:10, 04-08-2015, 23, 03, 2003
9, 18:32:45, 05-05-2015, 10, 05, 2015
10, 10:09:55, 10-10-2016, 19, 03, 2015
11, 0.555555, 20-10-2015, 12, 12, 2000
12, 7.45, 13-3-2015, 26, 10, 2005
13, 13:14:15, 01-01-2016, 24, 09, 2004
14, 10:10:10, 01-01-2015, 23, 12, 2013
15, 09:07:45, 12/10/2015 29, 10, 2000
];

After running the script, MakeDatetemp field returns null values.

Could anyone please explain me as to what is wrong in my code?

Thanks,

Asma

Re: Issue with MakeDate function

Anonymous — Thu, 12 May 2016 13:39:03 GMT

Makedate function returning strange dates... | Qlik Community

it is useful to you

Re: Issue with MakeDate function

marcus_sommer — Thu, 12 May 2016 13:42:18 GMT

The order of the makedate is wrong - it needs to be: makedate(year, month, day).

- Marcus

Re: Issue with MakeDate function

jonathandienst — Thu, 12 May 2016 13:42:25 GMT

The Makedate parameters are

MakeDate(Year, Month, Day) and not MakeDate(Day, Month, Year)

Re: Issue with MakeDate function

avinashelite — Thu, 12 May 2016 13:43:20 GMT

The right format is like this

date(MakeDate(Year,Month,Day),'DD-MM-YYYY') as MakeDateTemp,

MAKEDATE() will take parameters in particular order ...i.e. Year,Month and Day

Re: Issue with MakeDate function

MindaugasBacius — Thu, 12 May 2016 13:43:58 GMT

LOAD *,

Second(Time) as TimeSec,

Minute(Time) as TimeMin,

Hour(Time) as TimeHour,

date(MakeDate(Year, Month, Day),'DD-MM-YYYY') as MakeDateTemp

INLINE [

ID, Time, Date, Day, Month, Year

1, 09:45, 19-03-2016, 20, 05, 1990

2, 12:32:50, 10-05-2016, 10, 10, 2000

3, 04:55:55, 04-04-2015, 20, 12, 2012

4, 01:23:45, 22-09-2015, 15, 05, 2013

5, 06:07:32, 26-05-2015, 21, 01, 1995

6, 05:04:56, 24-07-2015, 30, 08, 2015

7, 03:45:55, 09-10-2015, 27, 09, 2014

8, 10:10:10, 04-08-2015, 23, 03, 2003

9, 18:32:45, 05-05-2015, 10, 05, 2015

10, 10:09:55, 10-10-2016, 19, 03, 2015

11, 0.555555, 20-10-2015, 12, 12, 2000

12, 7.45, 13-3-2015, 26, 10, 2005

13, 13:14:15, 01-01-2016, 24, 09, 2004

14, 10:10:10, 01-01-2015, 23, 12, 2013

15, 09:07:45, 12/10/2015 29, 10, 2000

];

Use this statement:

date(MakeDate(Year, Month, Day),'DD-MM-YYYY') as MakeDateTemp

Re: Issue with MakeDate function

Anonymous — Thu, 12 May 2016 13:44:19 GMT

use this (Change order of fields)

makedate(year,month,day)

Re: Issue with MakeDate function

riyazasma1009 — Thu, 12 May 2016 13:47:58 GMT

Thanks a lot everyone for the quick response...