Discussion board where members can get started with QlikView.
what is difference between date and date# function?
Date() is to format a number as date string / text, Date#() to interpret a string as date number.
With # is an interpretation function. To interpret dates from different formats to a qlikview date.
WIthout # is just a format mask, to manipulate how the date is displayed.
often when date# is used, date is used too to manipate the format
If you have date value but not in date format then you have to use Date# and then Date function to convert the date in to different date format
Date Value = 20140406 want to convert into 06/04/2014
=Date#(20140406,'YYYYDDMM') // By this function it will come into proper date number format if it is in not in proper date format and then
=Date(Date#(20140406,'YYYYDDMM'),'DD/MM/YYYY') //By use of Date it will convert into proper date format
Etc with many format you can use.
QlikView Date fields
Primer for QlikView Date fields