Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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?