Pass Through variable for date
I have a varchar pass through variable for a date with format (31/12/2011). In my columns, I also have a date, originally 20111231, which I converted to 31/12/2011 through SQL. If I try to use these on my parameters and filters, on the equal to and not equal to works. However, I need to be able to only draw the figures for the past 365 days from run date. Any ideas on how I could do this?
Views: 40
Replies to This Discussion
-
Permalink Reply by Terence Hinrichsen on -
Do you specifically want 365 days or would you not rather just use 1 year. I am just thinking out loud ( if that makes sense), but can't you take the SUBSTRING (@PTVAR@,6,4)-1 [or something like that] to just get the year out and then create a new field (concatenating the day, month, and the calculated year) and filter based on that... I would just add that filter on my Container Source instead of using it as a filter on the actual report...
-
Permalink Reply by Riekie Roux on -
Hi Terence, I will try this. I'm looking for 365 days specifically.
Follow Alchemex on twitter
Like Alchemex on facebook
© 2012 Created by Admin.
