Transfer

Posted by david on 28. June 2008 18:00

Useful Date Function

• CAST(FLOOR(CAST( someDateThing AS FLOAT))AS SMALLDATETIME)

 timeless dates:

•  SET @from = CAST( FLOOR(CAST( GETDATE() AS FLOAT) ) AS SMALLDATETIME)
•  SET @to = CAST( FLOOR(CAST( GETDATE() AS FLOAT) ) AS SMALLDATETIME)
•  (TTid, TTLabel, TTd1, TTd2, Context)

http://support.microsoft.com/kb/210604

SSRS

• DateAdd("d",-7,today())

SSRS

• Today.AddDays(-1)

SSRS

• DateSerial(Year(TODAY()),1,1)

TSQL

• Set @from = '01/01/' + convert(char(4),datepart(year,getdate()))

TSQL

• Select convert(varchar,dateadd(qq,0,DATEADD(qq,DATEDIFF(qq,0,getdate()), 0)),101)

TSQL

• SELECT dateadd(qq,0,DATEADD(qq,DATEDIFF(qq,0,getdate()), 0))

SSRS

• DateSerial(Year(Date()), Int((Month(Date()) - 1) / 3) * 3 + 1, 1)

TSQL

• SELECT dateadd(qq,1,DATEADD(qq,DATEDIFF(qq,0,getdate()),0))

SSRS

• DateSerial(Year(today()), Month(today())-0,1)

SSRS

• START DATE =Globals!ExecutionTime.AddDays(-7).Date

• END DATE =Globals!ExecutionTime.Date