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.