Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

what is difference between date and date# function?

what is difference between date  and  date# function?

5 Replies
swuehl
MVP
MVP

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

Not applicable
Author

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.

Not applicable
Author