topic Re: Need a Example which shows Difference between Date and Date# in QlikView

Need a Example which shows Difference between Date and Date#

SatyaPaleti — Wed, 09 Nov 2016 03:21:35 GMT

Hi Folks,

Can some one provide a Example which shows Difference between Date and Date#. it was really Required

Thank you,

Satya

Re: Need a Example which shows Difference between Date and Date#

mayankraoka — Wed, 09 Nov 2016 03:25:54 GMT

Hi,

Check this link

https://community.qlik.com/blogs/qlikviewdesignblog/2014/12/02/the-date-function

Regards,

Mayank

Re: Need a Example which shows Difference between Date and Date#

hemanthaanichet — Wed, 09 Nov 2016 04:32:12 GMT

Hi Sathya,

Interpretation(Date#()) vs Formatting(Date()):-

1.Interpretation functions use the textual value of the input, and convert this to a number.

2.Formatting functions use the numeric value of the input, and convert this to a text.

In both cases, the output is a dual, i.e. it has both a textual value and a numeric value. The textual value is displayed, whereas the numeric value is used for all numerical calculations and sorting.

Check this link which has exxamples too

https://community.qlik.com/blogs/qlikviewdesignblog/2014/12/02/the-date-function

Regards,

Hemanth

Re: Need a Example which shows Difference between Date and Date#

tresB — Wed, 09 Nov 2016 04:36:49 GMT

Check it here: Re: Date() vs Date#()

Re: Need a Example which shows Difference between Date and Date#

makoprovski — Thu, 02 Feb 2017 10:48:42 GMT

Here you can work with dates without doubts ..

Why don’t my dates work?

Get the Dates Right

Thanks Mr HIC hic