I can't seem to get a date query restriction to work.
rptdate is my date field
When you bring up the report the date looks like this 01/31/06
I am trying to restrict the end user so they can only see 01/01/2006
through 01/31/2007 for this report.
I have tried these in the Query restrictions
rptdate >='01/01/06' and rptdate <='01/31/07'
rptdate >=01/01/06 and rptdate <=01/31/07
What am I doing wrong?
CC=YES
INPEXIT=C:\PROGRA~1\IBM\ONDEMA~1\EXITS\ACIF\APKA2E
CCTYPE=Z
CONVERT=YES
CPGID=500
MCF2REF=CF
TRC=NO
FILEFORMAT=STREAM, (NEWLINE=X'0A')
TRIGGER1=*,2,X'D4F4F1F0F2',(TYPE=GROUP) /* M4102 */
FIELD1=0,8,8,(TRIGGER=1,BASE=0)
INDEX1=X'9997A38481A385',FIELD1,(TYPE=GROUP,BREAK=YES) /* rptdate */
DCFPAGENAMES=NO
UNIQUEBNGS=YES
IMAGEOUT=ASIS
INDEXOBJ=GROUP
INDEXSTARTBY=2
INSERTIMM=NO
FORMDEF=f1nol531
FDEFLIB=C:\OVERLAYS
PAGEDEF=p1nol531
PDEFLIB=C:\OVERLAYS
PSEGLIB=C:\OVERLAYS
OVLYLIB=C:\OVERLAYS
FONTLIB=C:\OVERLAYS
USERLIB=C:\OVERLAYS
RESLIB=C:\OVERLAYS
RESTYPE=FDEF,PSEG,OVLY
Thanks for the help
Jim