How to calculate yesterday records with today records using progress 4gl?

I have written a program and i need to calculate yesterday records(timing 12:00 AM to 05:00 AM) with today records

for each womf_worder of sfcf_au_ship where
womf_worder.word_production_status EQ "B" and
womf_worder.word_build_date EQ today - 1 and
womf_worder.word_build_time GE tt_shift.shft_start_hour and
womf_worder.word_build_time LE tt_shift.shft_stop_hour
no-lock:

assign i = i + 1.
end.


But the problem is I need to calculate the orders only on those mentioned time(12:00 AM to 05:00 AM) with today records. Could you please help this case?

Continue reading...