Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  Reporting Services Development  problem with count date between

Author  Topic  sun919 Starting Member 22 Posts Posted - 2006-10-13 : 00:58:49 Hi there i m newbie to this sql report thing and would like to ask a simple question regarding date I m trying to Count the no. of Date that are register after 1May 2006 from the table unfortunately the comparision date is not as i was expected since when i did it it give me error on syntax here is what i ve wrote =Count(Fields!Register.Value, "PatientDataSet_Patient" >= DateSerial(2006,05,01)) I ve try to replace Count with CountRows and still give me error so how do u deal with date in this sceanario many thanks sun