Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Difference between Date# and date ()

Difference between Date# and date ()

7 Replies
MK_QSL
MVP
MVP

Date is being used : number to string conversion

Date# is being used : string to number conversion

Not applicable
Author

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)

rajat2392
Partner
Partner

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

richard_pearce6
Luminary Alumni
Luminary Alumni

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

Not applicable
Author

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

PradeepReddy
Specialist II
Specialist II

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

venkatasreekant
Specialist
Specialist

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.