Snippets

Brendan Rice Jinbu - Set Data to Current Month

Created by Brendan Rice
SetData.sql
Raw 
1
2
3
4
5
6
update [DiaryData] set [Booked] = DATEFROMPARTS ( year([Booked]), 11, 30 )  where Day([Booked]) > 30
update [DiaryData] set [Booked] = DATEFROMPARTS ( year([Booked]), 11, day([Booked]) )  
update [LabourData] set [DateTo] = DATEFROMPARTS ( year([DateTo]), 11, day([DateTo]) )  
update [LabourData] set [EndOfMonthDate] = DATEFROMPARTS ( year([DateTo]), 11, 30) 
update [WipData] set [Created] = DATEFROMPARTS ( year([Created]), 11, 30 )  where Day([Created]) > 30
update [WipData] set [Created] = DATEFROMPARTS ( year([Created]), 11, day([Created]) )

Comments (0)

HTTPS SSH

You can clone a snippet to your computer for local editing. Learn more.