problem How to Count Date Between period

[sup919]

hi there,
I ve got a problem with trying to count the date between period of time ...
i ve try using

Count(Fields!Register.Value, "PatientDataSet_Patient" >= DateSerial(2006,05,01))

and it give me problem since i didnt understand much of Sql report service language what i actually want to count the date that register after 1st May 2006
please helps
i ve been struggle for ages

many thanks
sun

 

[Catadmin]

You need to use VB, not T-SQL script to do that sort of thing.

I think it's a hash between VB Script & VB .Net, but you'd have to play with the syntax to make sure.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"