Intraday - 1 hour

[n1ef5ng1]

Hi i have a report where it will execute loading of data @ 1015am. i would want the script to load everything except the current hour of the loading time as it is not a complete set of data.

FROM

[$(vLoad)Data\Intraday\Data.qvd]

(qvd)

WHEREDate=(FileTime() - MakeTime(1));

Something along this line but it doesnt work

[girirajsinh]

WHEREDate <= Timestamp(LocalTime()-MakeTime(1) )

or

WHEREDate <= Timestamp(Now()-MakeTime(1) )

[rahulpawarb]

Hello Ben,

If the Data.qvd file contains the Date and Time components then use below predicate logic in filter condition:

WHERE Date <= Today() & ' ' & MakeTime(Hour(Now())-1,Minute(Now()), Second(Now()))

Hope this will help.

P.S.: This is verify basic logic you can make use Date and Time functions to fine tune it.

Regards!

Rahul