Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I would like to create a report with all orders which are created after a specific date and time.
All orders have a created timestamp. I would like to see all orders which are created since 15:00 o'clock the day before today.
I tried different formats, but I can't get it done. Could someone please explain which format I need to use for the following fields to compare them?
Many thanks!
Kind regards,
Henco
Hi,
did you try to create in load script a field structured as YYYYMMDDHHMMSS? So it will be easy to comparate two integers...
S.
Hi Simone,
Thanks for your reply.
I tried to load the createdate from the oracle database like this: to_char(aoadorder.createdate,'DD-MM-YYYY HH24:MI')
In QV I created a variable like this: timestamp#(today()&' 15:00')
But when I compare these two, it has no effect. So I assume I do something wrong with the formats.
Kind regards,
Henco
Hi Henco,
I think you can use Timestamp#() function.After this it is just as simple as integer comparison.
Regards.
Hi,
In script create variable:
Let vTime = Time(Frac(Today()-1),'03:00');
In UI:
=sum({$<Date={'>=$(=today()-1)'}, Time = {'>=$(=vTime)'}>} Amount)
Regards
Neetha
Thanks, you pointed me in the right direction. Solved the problem by first checking the date and after that checking the time.
Regards,
Henco