Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

The difference between Date() and Date#()

Hi,

I can't under stand the difference between XXXX() function and XXXX#() function.

e.g. Date(), Date#().

Does anyone know this?

1 Solution

Accepted Solutions
Highlighted
Master
Master

Re: The difference between Date() and Date#()

Date#() is used how to interpret the data.  For example

date#('2013_24_10','YYYY_DD_MM') tells that the first four digits are year, the digits between two '_'s are Date, and the last two are Month.

Date() is used to tell how to show the data.  For example

date(today(),'YYYY_DD_MM') returns  2013_24_10

date(today(),'MM/DD/YY') returns  10/24/13

Combination of both:

date(date#('2013_24_10','YYYY_DD_MM'),'MM/DD/YYYY') returns 10/24/2013

View solution in original post

2 Replies
Highlighted

Re: The difference between Date() and Date#()

Date is a formatting function... just give it a display whereas Date#() is a interpretation function. It helps QlikView understand a date field which Qlik is not able to interpret by itself.

Highlighted
Master
Master

Re: The difference between Date() and Date#()

Date#() is used how to interpret the data.  For example

date#('2013_24_10','YYYY_DD_MM') tells that the first four digits are year, the digits between two '_'s are Date, and the last two are Month.

Date() is used to tell how to show the data.  For example

date(today(),'YYYY_DD_MM') returns  2013_24_10

date(today(),'MM/DD/YY') returns  10/24/13

Combination of both:

date(date#('2013_24_10','YYYY_DD_MM'),'MM/DD/YYYY') returns 10/24/2013

View solution in original post