-----------------------------------------------------------------------------
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)