Discussion board where members can get started with QlikView.
What is the difference between Date and Date# function?
Go to Solution.
The date# function formats any given string which holds a date to a vaild dateformat
The date function formats a valid date field to your liking
date('2015-08-18','MM/YY') will Show 08/15
View solution in original post
This post by HIC should clarify things.
Get the Dates Right
Also: QlikView Date fields
did you read this?
QlikView Date fields
Same as between Num() and Num#(). One does formatting for ouput, the other tries to convert a string into a numerical date representation.
See also here: What is the difference between Num and Num# function?
please check below post by henric:
The Date Function