what is difference between date and date# function?

[#1]

what is difference between date  and  date# function?

[swuehl]

Date() is to format a number as date string / text, Date#() to interpret a string as date number.

[#3]

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

[its_anandrjs]

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

Eg:-

Date Value = 20140406 want to convert into 06/04/2014

Then

=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

Eg:-

=Date(Date#(20140406,'YYYYDDMM'),'MM/DD/YYYY')

Or

=Date(Date#(20140406,'YYYYDDMM'),'YYYY/DD/MM')

Or

=Date(Date#(20140406,'YYYYDDMM'),'DD/MM/YY')

Etc with many format you can use.

[maxgro]

QlikView Date fields

Primer for QlikView Date fields

[#6]

QlikView Date fields