am trying to display the report time frame in the header of the report.
I have a report that retrieves date from current date - 12 hours. I tried below and I get yesterday.
=DATEADD("h", -12,(today))
if I run the report at 7:00 am I would like the start date to show
mm/dd/yyyy 7:00 pm and the end date to show mm/dd/yyyy 7:00 am.
I have no problem for my monthly reports
First day of last month:
=dateadd("m",-1,dateserial(year(Today),month(Today),1))
I don't know much about SSRS/reporting but isn't "TODAY" a date with no time? Isn't there something like "NOW" that does have both a date and a time associated with it?
@JeffModen is right, you should use NOW() if you want to get date and time. Then use DATEADD function and FORMAT function to do what you need. For example:
You can format it to your liking using the standard format strings from here or, if that does not meet your requirements, using the custom format strings on this page.