Hi all,
I am new to Telerik and stuck. Using Report Designer ver. 15.1.21.616. Have a basic table which has user names and timestamps for when their accounts were activated. Need to get a simple count of how many were activated in the last 30, 60 and 90 days. Tried with the main (server side) query such as
Select name, ActionTimeStamp from UserRequest where ActionTimeStamp > AddMonths(Today(),-1)
or,
Select name, ActionTimeStamp from UserRequest where ActionTimeStamp > DATEADD(day, -30, getdate())
to no avail; getting different kinds of errors.
Tried downloading the whole table (without a WHERE statement) and use an expression imbedded inside a Text Box to get the count. Just to make sure the function works, tried:
[= AddMonths(Today(),-1)]
and it works, it gives me the date 30 days before today. So tried to build on AddMonths(). Tried the following, and any combination that I could think of, and yet cannot get any results!!
[= "Recs last month: " + Count(CDate(Fields.ActionTimeStamp) > CDate(AddMonths(Today(),-1)))]
What am I doing wrong?
Greatly appreciate your help; thank you, guys,
Tony
Figured out the answer.
Select name, ActionTimeStamp from UserRequest where DATEDIFF(day, ActionTimeStamp , GETDATE()) < 60