Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Difference between Date# and date ()
Date is being used : number to string conversion
Date# is being used : string to number conversion
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)
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
Looking forward to the next question lifted from a popular blog.....
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
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...
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.