Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I wanted to load my dates only greater than the date 01.10.2020 in this format.
My loading script from Datawarehoue:
[Masterdata]:LOADSerialnumber,Date(Timestamp#(replace( Finishtime,' UTC',''),'YYYY-MM-DD hh:mm:ss'), 'DD.MM.YYYY') as FinishtimeFROM [lib://XXXXXXXXXXX](txt, utf8, embedded labels, delimiter is ',', msq)
Where Date(Timestamp#(replace( Finishtime,' UTC',''),'YYYY-MM-DD hh:mm:ss'), 'DD.MM.YYYY') > Date(Timestamp#(replace( Finishtime,' UTC',''),'2020-10-01 00:00:00'), 'DD.MM.YYYY');
Please disregard the fact that I have to use the replace function to get rid of the "UTC" since it arrives in qlik as a string and not date format.
I already put in the "bigger than 2020-10-01", but still I get no returns.
Hope someone knows why.
Thank you in advance.