search cancel

EASYTRIEVE report for a date/time range.

book

Article ID: 54352

calendar_today

Updated On:

Products

Jobtrac

Issue/Introduction

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

 

 

Environment

Release:
Component: JOBTRC

Resolution

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'