topic Re: Date ,Date# Vs MakeDate in QlikView

Date ,Date# Vs MakeDate

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

Hi All,

What is the difference between Date ,Date#Vs MakeDate?

Thanks in advance.

Re: Date ,Date# Vs MakeDate

Anil_Babu_Samineni — Mon, 27 Feb 2017 07:12:01 GMT

You will get many while start searching on google / Any SEO

Start from here

https://help.qlik.com/

Re: Date ,Date# Vs MakeDate

Peter_Cammaert — Mon, 27 Feb 2017 07:21:02 GMT

The search box is also a useful tool to find information, as this topic has been discussed more than a hundred tilmes before. Anyway:

Date = a formatting function the formats an existing date value according to either the default date format or the format you specify as 2nd parameter
Date# = an interpretation function that takes an unknown (string) value and tries to convert it into a regular QlikView (binary) date value according to either the default date format or the format you specify as 2nd parameter
MakeDate = a function that takes individual date components (separate day, month and year values as parameters) and assembles them into a regular QlikView (binary) date value

Best,

Peter

Re: Date ,Date# Vs MakeDate

rahulpawarb — Mon, 27 Feb 2017 07:33:16 GMT

In continuation to Peter's reply:

Date function example:

//This function will return Date field in MM/DD/YYYY format.
//You can mention format of your choice e.g. DD/MM/YY, DD-MMM-YY etc.
Date(DateKey, 'MM/DD/YYYY')  AS Date

Date# function example:

//This function will Interpret DateKey field in MM/DD/YYYY format. 
//You can mention format of your choice e.g. DD/MM/YY, DD-MMM-YY etc.
Date#(DateKey, 'MM/DD/YYYY')  AS Date

MakeDate function example:

//This function will return Date field by combining Year, Month & Day fields.
MakeDate(Year, Month, Day)  AS Date

Regards!

Rahul

Re: Date ,Date# Vs MakeDate

qlikviewwizard — Mon, 13 Aug 2018 10:04:56 GMT

Hi,

Please read this HIC's blog and Qlik Help. It is crystal clear.

The Date Function‌

Why don’t my dates work?

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/DateAndTimeFunctions/makedate.htm‌

Example	Result
makedate(2012)	returns 2012-01-01
makedate(12)	returns 0012-01-01
makedate(2012,12)	returns 2012-12-01
makedate(2012,2,14)	returns 2012-02-14

Hope this will help you.