difference between Date and Date# function

[qlikviewwizard]

Hi All,

What is the difference between Date and Date# function?

[b_garside]

This post by HIC should clarify things.

Get the Dates Right

Also: QlikView Date fields

[maxgro]

did you read this?

Get the Dates Right

QlikView Date fields

[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 · Accepted solution]

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]

Hi Qlik,

please check below post by henric:

The Date Function

Regards

Neetha