Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

what difference between two function[ date(),date#() ]

What is difference between these two function.

1) date()

2) date#()

Regards

Ashish Srivastava

2 Replies
shumailh
Creator III
Creator III

The only difference i found here is the date function accepts the expressions having values in numeric form like i.e. 35648 whereas date# is only use to evaluate the date data expression.

Regards,
Shumail

Not applicable
Author

date() takes a number that can be expressed as a date and expresses it in the default format unless otherwise specified.

e.g. Date(40379) may return a 20/07/2010 and date(40379,'MM-DD-YYYY') would return 07-20-2010

date#() will take in a date in an odd format and convert it to a date format. e.g. in my database we have a date in the format yyyymmdd

so date#('20100720','YYYYMMDD') would make this recognisable as a date. so to get that in the same format as above you would have to perform the date() function on it.

e.g. date(date#('20100720','YYYYMMDD'))

returns '20/07/2010'