Search results for query: *

Hi, Im working on the same report. I know how to get dates between January to Todays. but I want to get dates from Today to Decemeber or whatever month to whatever month. (DATEPART(m, bdate) = @StartMonth AND DATEPART(d, bdate) <= 31 OR DATEPART(m, getdate()) = @EndMonth AND DATEPART(d...

Thanks for replying RiverGuy. I have no idea what is .aspx page? is it complicated?

question is: IF I want to add a Calendar in SSRS which I know how to do which pulls data from this year 2010. In that I use startDate and EndDate on bdate column. For my report I want to add a calendar where it looks for older year date. FOr example: If I click on August 3rd and EndDate Sept...

Still the same doesnt give me any result :/

Thanks so much for helping me but this gives me nothing, no result at all. hmm..

(DATEDIFF(year, bdate, DATEADD(s, - 1, DATEADD(mm,DATEDIFF(m, 0, GETDATE()), 0))) = 18) This gives me closest results but only problem is that it starts from January not from current month. Any suggestion to this one?

Markros: This give me members with age 18 and less.. I only want to see members turning 18 this year (starting from the current month) :(

Ian thanks for replying. When I do use the Year(bdate) <= Year(getdate()) - 18 It gives me all the members with age greater than 18. What I want is, members turning 18 this year starting from the current month. So, for this month it would start from August 1st. and i dont know how to get...

question is: IF I want to add a Calendar in SSRS which I know how to do but that pulls data from this year 2010. In that I use startDate and EndDate on bdate column. But that doesnt work, reason is it only looks at the current year not old year. FOr example: I would click on August 3rd and...

Hi, I have been stuck at this for sometime. I will appreciate if someone helps me. I have a date of birth column and one age column. In the final result I would like to see members turning 18 this year starting from today so today would be (1st of month...August 1st 2010). In crystal, the...