Need a Example which shows Difference between Date and Date#

[SatyaPaleti]

Hi Folks,

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

Thank you,

Satya

[mayankraoka]

Hi,

Check this link

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

Regards,

Mayank

[hemanthaanichet]

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

[tresesco]

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

[makoprovski]

Here you can work with dates without doubts ..

Why don’t my dates work?

Get the Dates Right

Thanks Mr HIC hic