October 17, 2014 at 2:21 am
Hi
I'm showing previous day's results on a report, So I want to include the date on my header, this is what I have currently;
=Globals!ReportName & " on " & (Format(NOW,"dd MMM yyyy") -1)
I get an error there, how do I fix it to show the previous day's date.
October 17, 2014 at 2:48 am
Try this:
=Globals!ReportName & " on " & Format(DATEADD(DAY,-1,NOW()),"dd MMM yyyy")
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 17, 2014 at 6:15 am
Getting an error on "DAY"
October 17, 2014 at 6:40 am
What is the error?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 17, 2014 at 8:24 am
Argument not specified for parameterValue of Public Day(DateVlaue) As Integer
October 17, 2014 at 9:29 am
=Globals!ReportName & " on " & Format(DateAdd(DateInterval.Day, -1, NOW), "dd MMM yyyy")
or
=Globals!ReportName & " on " & Format(DateAdd("d", -1, NOW), "dd MMM yyyy")
October 20, 2014 at 12:19 am
Thank you.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply