Snippet from Stevienova that will return yesterdays date for use in a parameter.
No comment on it effectiveness as I haven’t tested it or analyzed it.
Posted by: Charlie Maitland | Tuesday 23 January, 2007
MDX for using Yesterdays date in a SSRS Parameter
Posted in Uncategorized
Try this(smaller):
=”[Time].[Calendar Date].&[” & Today().AddDays(-1).ToString("yyyy-MM-ddT00:00:00]“)
By: Steffo on Saturday 3 February, 2007
at 9:58 am