topic Converting YYYY-MM-DD to DD-MM-YYYY in IF( function in QlikView

Converting YYYY-MM-DD to DD-MM-YYYY in IF( function

Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Converting YYYY-MM-DD to DD-MM-YYYY in IF( function

Anil_Babu_Samineni — Fri, 06 Jan 2017 08:57:27 GMT

How about this? Might not sure i understand fully

Date(Left(ISOTimeNotation, 8),'YYYY-MM-DD')

Date(Date#(Left(ISOTimeNotation, 8),'YYYY-MM-DD'),'DD-MM-YYYY')

Re: Converting YYYY-MM-DD to DD-MM-YYYY in IF( function

varshavig12 — Fri, 06 Jan 2017 09:04:14 GMT

alt function can be used for multiple date formats.