topic what is difference between date and date# function? in QlikView

what is difference between date and date# function?

Wed, 04 Jun 2014 17:58:55 GMT

what is difference between date and date# function?

swuehl — Wed, 04 Jun 2014 18:05:23 GMT

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

Wed, 04 Jun 2014 18:05:56 GMT

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 — Wed, 04 Jun 2014 18:08:40 GMT

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')

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

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

Etc with many format you can use.

maxgro — Wed, 04 Jun 2014 19:04:23 GMT

Wed, 04 Jun 2014 19:08:29 GMT