Discussion Board for collaboration related to QlikView App Development.
I can't under stand the difference between XXXX() function and XXXX#() function.
e.g. Date(), Date#().
Does anyone know this?
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
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.