Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

what is difference between date and date# function?

what is difference between date  and  date# function?

5 Replies
Highlighted
MVP
MVP

Re: 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.

Not applicable

Re: what is difference between date and date# function?

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

Re: what is difference between date and date# function?

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.

MVP
MVP

Re: what is difference between date and date# function?

Not applicable

Re: what is difference between date and date# function?