Need a Example which shows Difference between Date and Date#

SatyaPaleti — Wed, 25 Nov 2020 16:16:04 GMT

Hi Friends,

Can some one provide a a Example which shows Difference between Date and Date#

Thank you,

Satya

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

varshavig12 — Wed, 09 Nov 2016 03:25:48 GMT

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

Anonymous — Wed, 09 Nov 2016 05:18:43 GMT

Hi Satya,

Please refer following link for a good understanding of date function:-

QlikView Addict: Dates in QlikView - Part 2

The date#() function interprets a string using the given format and creates a true date from it.

Its straightforward to use as follows:

date#(DateStringField, 'YYYY-MM-DD') AS DateField

The function interprets the field DateStringField using the format YYYY-MM-DD and if it can do so, outputs a true date.

QlikView stores dates as a dual value; the numerical representation of the date and a string representing how the date will be presented to the user. One thing worth noting about the date#() function is that the resulting date will be formatted using the same format used to interpret the string, which might not be the format you desire your dates to be displayed in. You should also remember that we can use the date() function to format the string part of a true date and so we can add it to the above code as follows:

date(date#(DateStringField, 'YYYY-MM-DD'), 'DD-MM-YYYY') AS DateField

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

tresB — Wed, 09 Nov 2016 05:27:39 GMT

Duplicate thread should be avoided: Need a Example which shows Difference between Date and Date#

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

Need a Example which shows Difference between Date and Date#

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

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

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