MS SSRS tutorial on data parameter defaults and data formatting.
This is a Microsoft SSRS tutorial video demonstrating how to create defaults on date parameters. This tutorial uses functions: Now, Today, DateAdd, DatePart, DateSerial, Day, Month, Year, CDate, Format and FormateDateTime. This video shows how to default date parameters with todays date, default to start of current month, default to start of last month, default to end of last month and default to 7 months ago.
Default today: =Today
Default start of month: =DateSerial(Year(Today), Month(Today), 1)
Default start of last month: =DateAdd(DateInterval.Month, -1, DateSerial(Year(Today), Month(Today), 1))
Default end of last month: =DateAdd(DateInterval.Day, -Datepart(DateInterval.Day, Today), Today)
Default start of month 7 months ago????: =DateAdd(DateInterval.DayOfYear, -Datepart(DateInterval.DayOfYear, DateAdd(DateInterval.Month, -1, Today)) + 1, DateAdd(DateInterval.Month, -3, Today))
Textbox:
="todays date is: " + FormatDateTime(Today)
="todays date is: " + Format(CDate(Today), "dd MMM yyyy")
="todays date is: " + Format(CDate(Today), "dd-MM-yyyy")