SETRANGE Based on time

Washout

Hi,

I have a table with a TIME field in it.

I have to write a codeunit which will run as a scheduled task hourly.

So if the task runs at XX:59:59 every hour then it needs to return all rows where the TIME field in the tableis XX hours.

is this done by SETRANGE and how?

thannks in advance

rajpatelbca

Why cant you use job schedular for that?
you have to use timer automation control for that.

CP Timer automation control helps you to complete this task.

kriki

In the other case, the code would be:

intHour : integer
timStart,timStop : time

intHour := 23;
timStart := 000000T + (23 * 60 * 60 * 1000);
timstop := timstart + ((((59 * 60) + 59) * 1000) + 999);

...
SETRANGE("The Time",timstart,timstop);
...