Timstamp calculation issue 2

Tue, 08 Nov 2016 12:40:58 GMT

Hi guys,

please I have this timestamp format in my database timestamp= 2016-11-01 00:00:00.0000000 +00:00 and I convert it to this format Date = 2016-11-01 by using this expression in my script: Date#(SubField(timestamp, ' ', 1),'YYYY-MM-DD')

I want whenever I choose a date for example 2016-11-01, I want to get the value of the th field quantity_value of this timestamp 2016-11-01 05:59:57.1810000 +00:00, and if I choose 2016-11-02 i want to get the value of this timestamp 2016-11-02 05:59:57.1810000 +00:00 and so go on.

Please help me.

topic Timstamp calculation issue 2 in QlikView

Timstamp calculation issue 2