September 2015

  Good link to review the possible paths: http://waqasb.blogspot.com/2014/12/dynamics-gp-2015-upgrade-process-paths.html

    First Date of last month =DateAdd(“m”, -1, DateSerial(Year(Now()), Month(Now()), 1)) =Today.AddDays(1- Today.Day).AddMonths(-1) Last date of last month =DateAdd(“d”, -1, DateSerial(Year(Now()), Month(Now()), 1)) =Today.AddDays(-1.0 * Today.Day) First date of current month =DateSerial(Year(Now()), Month(Now()), 1) =Today.AddDays(1 – Today.Day) Last date of current month =DateAdd(“d”,-1,(DateAdd(“m”, 1, DateSerial(Year(Now()), Month(Now()), 1)))) =Today.AddDays(-1 * Today.Day).AddMonths(1) Yesterday’s date  =DateAdd(“d”, -1,…

  /* Handy Date Stuff */ —-Today SELECT GETDATE() ‘Today’   –Full Day SELECT CAST(GETDATE() as date) AS DT  —-Yesterday SELECT DATEADD(d,-1,GETDATE()) ‘Yesterday’  —- Previous Day  DATEADD(day, DATEDIFF(day, 0, yourDate), 0)   —-First Day of Current Week SELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),0) ‘First Day of Current Week’  —-Last Day of Current Week SELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),6) ‘Last Day of Current Week’  —-First…