SSRS日期參數的初始化

-----------------------------------------------------------------------------

1、本月第一天

=DateSerial(YEAR(Today()), MONTH(Today()), 1)

2、本月最後一天

=DateAdd(“d”,-1,(DateAdd(“m”, 1, DateSerial(Year(Today()), Month(Today()), 1))))

3、上月第一天

=DateAdd(“m”, -1, DateSerial(Year(Today()), Month(Today()), 1))

4、上月最後一天

=DateAdd(“d”, -1, DateSerial(Year(Today()), Month(Today()), 1))

5、下月第一天

=DateAdd(“m”, 1, DateSerial(Year(Today()), Month(Today()), 1))

6、下月最後一天

=DateAdd(“d”,-1,(DateAdd(“m”, 2, DateSerial(Year(Today()), Month(Today()), 1))))

7、本年第一天

=DateSerial(YEAR(Today()), 1, 1)

8、本年最後一天

=DateSerial(YEAR(Today()), 12, 31)

9、去年第一天

=DateAdd(“yy”, -1, DateSerial(YEAR(Today()), 1, 1))

10、去年最後一天

=DateAdd(“d”, -1, DateSerial(YEAR(Today()), 1, 1))

-----------------------------------------------------------------------------

1.SSRS得到某一天本周的周一

=DateAdd("d", -(WeekDay(Parameters!From.Value,FirstDayOfWeek.Monday))+1, Parameters!From.Value)

2.SSRS得到某一天下周的周一

=DateAdd("d", 8-WeekDay(Parameters!From.Value,FirstDayOfWeek.Monday), Parameters!From.Value)

3.SSRS得到某個月的第一天

=DateSerial(YEAR(TODAY), MONTH(TODAY), 1)

4.SSRS得到某個年的第一天

=DateSerial(YEAR(TODAY), 1, 1)

5.SSRS得到去年的第一天

=DateSerial(YEAR(TODAY)-1, 1, 1)

Date Format	VB Functions	.Net Functions
First Date of last month	=DateAdd(“m”, -1, DateSerial(Year(Now()), Month(Now()), 1))	=Today.AddDays(1- Today.Day).AddMonths(-1)
Last date of last month	=DateAdd(“d”, -1, DateSerial(Year(Now()), Month(Now()), 1))	=Today.AddDays(-1.0 * Today.Day)
First date of current month	=DateSerial(Year(Now()), Month(Now()), 1)	=Today.AddDays(1 – Today.Day)
Last date of current month	=DateAdd(“d”,-1,(DateAdd(“m”, 1, DateSerial(Year(Now()), Month(Now()), 1))))	=Today.AddDays(-1 * Today.Day).AddMonths(1)
Yesterday’s date	=DateAdd(“d”, -1, Today)	=Today.AddDays(-1)
Tomorrow’s date	=DateAdd(“d”, 1, Today)	=Today.AddDays(1)
First day of current year	=DateSerial(Year(Now()), 1, 1)	=Today.AddDays(1- Today.DayOfYear)
Last day of current year	=DateSerial(Year(Now()), 12, 31)	=Today.AddDays(-1 * Today.DayOfYear).AddYears(1)
Last day of current year	=DateSerial(Year(Now()), 12, 31)	=Today.AddDays(-1 * Today.DayOfYear).AddYears(1)

以下是SQL語句，和SSRS有差別:

本年第一天

DateAdd(yy,DateDiff(yy,0,getdate()),0)

本季度第一天

dateAdd(qq,DateDiff(qq,0,getdate()),0)

本月的第一天

DateAdd(mm,DateDiff(mm,0,getdate()),0)

本周的第一天

DateAdd(wk,DateDiff(wk,0,getdate()),0)