Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey all,
In some of the qlikview logfiles that im loading into qlikview are ISO time notations like this: 20160916T052550.159+0200
And the other time notations are just normal YYYY-MM-DD notations.
In an IF function I converted the ISO times to normal times and they changed to a DD-MM-YYYY notation.
If(Wildmatch(Timestamp, '*T*'), Timestamp(Timestamp#(Timestamp)), Timestamp) as TS
So now i have two different time notations. (YYYY-MM-DD and DD-MM-YYYY)
I tried converting the YYYY-MM-DD notation by using the Date(Date#(Timestamp, 'YYYY-MM-DD'), 'DD-MM-YYYY') function inside the IF function used above.
This didnt work unfortunately.
Is there any way to solve this problem?
alt function can be used for multiple date formats.
How about this? Might not sure i understand fully
Date(Left(ISOTimeNotation, 8),'YYYY-MM-DD')
Or
Date(Date#(Left(ISOTimeNotation, 8),'YYYY-MM-DD'),'DD-MM-YYYY')
alt function can be used for multiple date formats.