Monthly Archives: November 2016

Linkdump: Excel VBA

Debugging keys: More debugging, esp. the Debug object: User forms: VBA for filter/copy/paste:

Posted in Excel, Linkdump | Leave a comment

SQL Server: time zone adjustment that accounts for Daylight Saving Time changes

This pulls the calendar for Daylight Saving Time from the server. DECLARE @time_in DATETIME SET @time_in = GETDATE() — SET @time_in = ‘2016/10/15 09:20:00 pm’ DECLARE @timezone_adjustment INT SET @timezone_adjustment=DATEDIFF(hh,GETUTCDATE(),GETDATE()) DECLARE @time_string NVARCHAR(60) –Convert from stored UTC datetime to local. … Continue reading

Posted in Programming, SQL Server | Leave a comment

Linkdump: CSS within MS Word    

Posted in Uncategorized | Leave a comment