Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
qlikviewwizard
Honored Contributor II

difference between Date and Date# function

Hi All,

What is the difference between Date and Date# function?

1 Solution

Accepted Solutions
Partner
Partner

Re: difference between Date and Date# function

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
Partner
Partner

Re: difference between Date and Date# function

This post by HIC should clarify things.

Get the Dates Right

Also: QlikView Date fields

MVP
MVP

Re: difference between Date and Date# function

Re: difference between Date and Date# function

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

Partner
Partner

Re: difference between Date and Date# function

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
Honored Contributor

Re: difference between Date and Date# function

Hi Qlik,

please check below post by henric:

The Date Function

Regards

Neetha