Date format query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Date format query

Author

Topic

venkatperi
Starting Member

1 Post

Posted - 2010-06-16 : 05:00:47

Hi All,

I have 2 date columns. One is leavedate and the second one is equipmentreturndate.

if person leaves on Monday, Tuesday, Wednesday, Thursday and Friday of this week, he has to return equipment on Next Friday always.

I want dateformat for equipmentreturndate.

in SQL Server reporting services we have =DateAdd("ww",1,DateAdd("d",5-DatePart("w",Fields!leavedate.Value,vbMonday),Fields!leavedate.Value)).

How can I use this in standard TSQL Format.

suneelcse
Starting Member

2 Posts

Posted - 2010-06-16 : 05:38:43

Hi Try this,
select equipmentreturndate=Dateadd(d,13-datepart(w,leavedate),leavedate)

let me know if it worked

Suneel k R

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources