topic Re: Date() vs Date#() in QlikView

Date() vs Date#()

Thu, 24 Oct 2013 17:09:43 GMT

Can someone illustrate the difference between the two?

Anonymous — Thu, 24 Oct 2013 17:17:37 GMT

Date#() is used how to interpret the data. For example

date#('2013_24_10','YYYY_DD_MM') tells that the first four digits are year, the digits between two '_'s are Date, and the last two are Month.

Date() is used to tell how to show the data. For example

date(today(),'YYYY_DD_MM') returns 2013_24_10

date(today(),'MM/DD/YY') returns 10/24/13

Combination of both:

date(date#('2013_24_10','YYYY_DD_MM'),'MM/DD/YYYY') returns 10/24/2013

Regards,

Michael

Thu, 24 Oct 2013 17:19:31 GMT

Very helpful. Thanks!

Thu, 27 Feb 2014 15:36:02 GMT

I have an issue with date() and date#(),i have field called ActionDate which is in this format 'DD/MM/YYYY'

and I have a field in the script that calculates DDMM like this

date#(date(CalendarDate,'DDMM'),'DDMM') Do you think there is a redundancy in this expression? thank you

MK_QSL — Thu, 27 Feb 2014 15:57:17 GMT

You can read this useful document.

Thu, 27 Feb 2014 16:54:49 GMT

Thank you for your help Manish.

Sun, 09 Nov 2014 09:18:00 GMT

thank you it was a nice Demo

Sun, 09 Nov 2014 11:56:50 GMT

use this document which is very helpful