
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Date ,Date# Vs MakeDate
Hi All,
What is the difference between Date ,Date#Vs MakeDate?
Thanks in advance.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You will get many while start searching on google / Any SEO
Start from here

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
