Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewwizard
Master II
Master II

difference between Date and Date# function

Hi All,

What is the difference between Date and Date# function?

1 Solution

Accepted Solutions
Anonymous
Not applicable

The date# function formats any given string which holds a date to a vaild dateformat

e.g. date#('2015-08-18','YYYY-MM-DD')

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

5 Replies
b_garside
Partner - Specialist
Partner - Specialist

This post by HIC should clarify things.

Get the Dates Right

Also: QlikView Date fields

maxgro
MVP
MVP

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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?

Peter

Anonymous
Not applicable

The date# function formats any given string which holds a date to a vaild dateformat

e.g. date#('2015-08-18','YYYY-MM-DD')

The date function formats a valid date field to your liking

date('2015-08-18','MM/YY') will Show 08/15

Anonymous
Not applicable

Hi Qlik,

please check below post by henric:

The Date Function

Regards

Neetha