EASYTRIEVE report for a date/time range.

Document ID : KB000054352
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

In Jobtrac 3.5 used JREPORT LIST HISTORY with a date range and time. How to code in Jobtrac 11.0?

Solution:

SAMPLE:

Jobtrac 3.5 JREPORT
LIST HISTORY
  END(FROM(DATE(*-00/01/00)TIME(07:00:00))
   TO  (DATE(*)TIME(07:00:00)));

Jobtrac 11.0
Set up your JMF with the following:

OSDDATE:-01
TODDATE:-01
Y=&:GYYYY
M=&:GMM
D=&:GDD

In GJTREZJS report used

DEFINE EVT1-F-TGTFDAT  EVT1-FILTERS  +157 10 A VALUE '&:Y./&:M./&:D'
DEFINE EVT1-F-TGTFTIM  EVT1-FILTERS  +167  8 A VALUE '07:00:00'
DEFINE EVT1-F-TGTTDAT  EVT1-FILTERS  +175 10 A VALUE 'TODAY'
DEFINE EVT1-F-TGTTTIM  EVT1-FILTERS  +185  8 A VALUE '07:00:00'