Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
What is the difference between Date ,Date#Vs MakeDate?
Thanks in advance.
Hi,
Please read this HIC's blog and Qlik Help. It is crystal clear.
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.
You will get many while start searching on google / Any SEO
Start from here
The search box is also a useful tool to find information, as this topic has been discussed more than a hundred tilmes before. Anyway:
Best,
Peter
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
Hi,
Please read this HIC's blog and Qlik Help. It is crystal clear.
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.