subtract date fileds

[balanandam]

Hi,

I have the data loaded from Mongodb to qlikview, I am unable to subtract data fields like data from other sources ex: MySQL

Start time: 20-04-2018 05:51:34

End time: 20-04-2018 05:43:11

wrote in qlikview as below:

Interval(Timestamp([sessionEndTime],'DD-MM-YYYY hh:mm:ss')-Timestamp([sessionStartTime],'DD-MM-YYYY hh:mm:ss'),'ss') AS Duration

Note: I am using REST connector to read the data from Mongo database and the data format is JSON

Pls. advice.

Br, Balanandam

[tresesco]

Try using timestamp#() instead.

[sasiparupudi1]

Interval(Timestamp#([sessionEndTime],'DD-MM-YYYY hh:mm:ss')-Timestamp#([sessionStartTime],'DD-MM-YYYY hh:mm:ss'),'ss') ASDuration

[balanandam]

Thanks for response, tried this, didn't worked.

Br, Balanandam

[balanandam]

Hey Sasidhar,

its working. My bad unable to set the format.

Thank You!

Br, Balanandam

[sasiparupudi1]

Great, Please close the thread by marking a correct answer