May I know the different between Date and Date# ?

[#1]

Hi All,

May I know the different between Date and Date# ?

Could you give me an example?

Thanks.

[#2]

The date# function evaluates the expression as a date according to the string givenSome times input of date in qlikview is in string rather than actual date format.Inthat case we use DATE#  ex:-(JAN2011)

Where as Date is used for format read in qlikview as date format.

Thanks

Vivek

[#3]

Thanks for your reply, but why this does not work?

=date#(20110113,'YYYY/MM/DD')

It always shows the result:20110113 not 2011/01/13

[#4]

hi again,

I hope this application will help you to understand diffrence between Date & Date#

Thanks

Vivek

[#5 · Accepted solution]

Please use this

=Date(date#(20110113,'YYYYMMDD') ,'YYYY/MM/DD')

[#6]

Could you tell me why I must use another Date function on it?

[#7]

It is because 20110113 is a string.First we need to understand qlikview that it is a date string not a normal string i.e done by Date# function then only we can apply date function on it to hange the format.

[Sokkorn]

Hi lzq_isaac,

Maybe check help on QlikView can answer to your subject.

Regards,

Sokkorn Cheav