Hi

When I run the report in Crystal I am getting more records than if I run it from INfor CM-->report section.

I was thinking that this happend because of the SLX adapter and GMT time.

I changed the report condition but still  the same issue.

(  ---- this is origianl--  meeting day is the same as literature date
     (DateDiff ("d",{HISTORY.COMPLETEDDATE} ,{LITREQUEST.SENDDATE} )=0 or
      DateDiff ("d",{HISTORY.COMPLETEDDATE} ,{LITREQUEST.REQDATE} )=0)
    
or   ---- added to compare dates using  GMT converstion 
      datediff("d",ShiftDateTime({HISTORY.COMPLETEDDATE}, ",0,GMT","") , ShiftDateTime ({LITREQUEST.SENDDATE}, ",0,GMT",""))=0
  
or
      datediff("d",ShiftDateTime({HISTORY.COMPLETEDDATE}, ",0,GMT","") , ShiftDateTime ({LITREQUEST.REQDATE}, ",0,GMT",""))=0

)

Any idea?

thanks!