Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have date format like shown below. How should I read this in QV.
Date:
14/5/2016 |
04/05/16 |
29/4/2016 |
01/05/16 |
30/4/2016 |
31/5/2016 |
29/4/2016 |
27/4/2016 |
03/05/16 |
30/4/2016 |
I think if Date coming as string then we need to use Date# only.. SET will not be able to recognize the format
hI
CHK THIS
I am going to test that out right now
yes kush set is not working
Check out the attached:
SET DateFormat='DD/MM/YYYY';
Table:
LOAD Date(A) as Date
FROM
Community_217289.xlsx
(ooxml, no labels, table is Sheet1);
Excel
QV
i dnt know why it is not workng for me
Looks ok, but I still have doubt, otherwise Date# function would no longer be available in QlikView to interpret string values as Date
Well it would be still needed when formats are like this
25/01/2016
01/25/2016
This cannot be handled without Alt()
but it seems this can:
25/01/2016
25/01/16
Need to test on other sources as well.
Other source?