topic Re: Difference between Date# and date () in QlikView

Difference between Date# and date ()

Thu, 08 May 2014 12:47:01 GMT

Difference between Date# and date ()

Re: Difference between Date# and date ()

MK_QSL — Thu, 08 May 2014 12:59:41 GMT

Date is being used : number to string conversion

Date# is being used : string to number conversion

Re: Difference between Date# and date ()

Thu, 08 May 2014 13:06:19 GMT

I remember them like this from there usage standpoint

Date

Use to convert date to the required format.

Date#

Qlikview is intelligent to find date filed and covert to date format during the load. If for some reason it did not recognize the format and treats it as a string. we can use Date# to help Qlikview interpret it as a date format. (we have to provide the date format for interpretation)

Re: Difference between Date# and date ()

rajat2392 — Thu, 08 May 2014 13:07:55 GMT

Hi Chandramohan

All dates are stored as numbers only at the back-end, and shown to you as a date.

So Date() will just store a date as number in the back-end and show you as a date.

While Date#() will do the same as Date() and can also change the text into a date, will store it as number and show you as date.

For better Understanding do one thing, take 2 text object and give these expression in each, you will get the difference

Date#(Text(today()))

Date(Text(today()))

Regards

Rajat

Re: Difference between Date# and date ()

richard_pearce6 — Thu, 08 May 2014 13:11:41 GMT

Looking forward to the next question lifted from a popular blog.....

Re: Difference between Date# and date ()

Thu, 08 May 2014 13:14:25 GMT

I promise, after you read this, you can become master on how to handle dates

http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/19/why-don-t-my-dates-work

Re: Difference between Date# and date ()

PradeepReddy — Thu, 08 May 2014 13:14:56 GMT

Date() : number to string conversion

Date#() : string to number conversion

the doc at the bellow link gives you the full idea about the dates functionality...

http://community.qlik.com/docs/DOC-3102

Re: Difference between Date# and date ()

Anonymous — Thu, 08 May 2014 13:56:30 GMT

date function formats the expression as a date according to the string given as format-code.

Date(Today(),'DD/MM/YYYY') -->

date# function evaluates the expression as a date according to the string given as format-code. If the format code is omitted, the default date format set in the operating system is used.