Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
Can some one provide a a Example which shows Difference between Date and Date#
Thank you,
Satya
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
Duplicate thread should be avoided: Need a Example which shows Difference between Date and Date#