Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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
Partner

This post by HIC should clarify things.

Get the Dates Right

Also: QlikView Date fields

maxgro
MVP
MVP

Peter_Cammaert

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

View solution in original post

neetha_p
Master
Master

Hi Qlik,

please check below post by henric:

The Date Function

Regards

Neetha