View Thread
HeavenCore | IT Solutions Built on Open Source Software » HeavenCore Central » SQL Functions
 Print Thread
Get Week End Date (Sunday) of any date regardless of DATEFIRST
admin
Top  #1 Print Post
Posted on 25-10-2011 13:51
Simple function to Get week end Date (Sunday) of any date regardless of DATEFIRST

Code Download source  

CREATE FUNCTION [dbo].[udf_WeekEndDate] ( @Date DATETIME )

RETURNS DATETIME

AS 

    BEGIN

        RETURN DATEADD(DAY, 7, CONVERT(DATETIME, CONVERT(VARCHAR(10), DATEADD(day, -1 - ( DATEPART(dw, @Date) + @@DATEFIRST - 2 ) % 7, @Date), 103) + ' 23:59:59', 103))

    END

GO
Edited by admin on 25-10-2011 14:05
Jordon Pilling | Heavencore Administrator
 
Web
Jump to Forum
8,018,139 unique visits
Powered by PHPFusion Copyright © 2024 PHP Fusion Inc
Released as free software without warranties under GNU Affero GPL v3.
Theme designed by Falcon
Copyright HeavenCore © 2005 - 2019 by Jordon Pilling
Data backups secured by Dekart Private Disk