I need only the days and hours stored - Qlik Community

qlikconsultant · ‎2015-11-25

I have the following Code in the load script:

interval(Endtimestamp-Starttimestamp,'DD-hh') as Timedifference

How can i save the Timedifference only as DD:mm?

PrashantSangle · ‎2015-11-25

Hi,

try

interval(Endtimestamp-Starttimestamp,'DD:mm')

or

interval(Endtimestamp-Starttimestamp,'hh:mm')

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Mark_Little · ‎2015-11-25

Hi

Wrap in he timestamp function.

Timestamp(Now(),'DD:mm')

either the expression or as proceeding load.

Mark