Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

get first monday of month sql

select DATEADD(wk, DATEDIFF(wk,0,
            dateadd(dd,6-datepart(day,getdate()),getdate())
                               ), 0)  
--Change getdate to your variable
 
PREVIOUS NEXT
Tagged: #monday #month #sql
ADD COMMENT
Topic
Name
8+6 =