Hi I have a report that I am outputting in Active report. When I try to filter on a date column, in the report. If I use a =(equal) then the result ends up being =>(equal or greater than). Why is this?

This message has been edited. Last edited by: Kerry,

It works for me with:

TABLE FILE GGSALES
PRINT DATE
ON TABLE PCHOLD FORMAT AHTML
END

I guess what kind of DATE field do you have? How's it defined?

Depends on the DBMS. If you're using SQL Server, dates are formatted differently than FOCUS, DB2 or Oracle, for instance.

Note, this is also an issue when creating an output FORMAT of an EXCEL pivot table, which behaves similarly to an AHTML active report packet.

Microfich,

I am using SQL Server, have you had this happen to you and if so what did you do to fix the problem.

the solution would seem to be:
create an extract file,
redefine the date to a focus smart date,
create the final report as an active report with filters.

Here's the one-liner I used to correct the problem with SQL Server dates:

  

UPDATE_DATE/A20 = HCNVRT(UPDATE_DATE, '(HYYMDS)', 20, 'A20');