"20140231",
SELECT TOP 1000 [Advise no] ,[Amount] ,[Date] ,[Bas Fund Description] ,[Invoice Date] (MONTH, DATEDIFF(MONTH, 0, [Invoice Date]), 0) AS months , CASE WHEN [Invoice Date] BETWEEN 20170401 AND 20170631 THEN 'Q1' WHEN [Invoice Date] BETWEEN 20170701 AND 20170931 THEN 'Q2' WHEN [Invoice Date] BETWEEN 20171001 AND 20171231 THEN 'Q3' WHEN [Invoice Date] BETWEEN 20180101 AND 20180331 THEN 'Q4' WHEN [Invoice Date] Is Null THEN 'Null' END AS QuarterPeriod ,[Valuation Date] ,[qgs_geometry] ,[qgs_fid] ,[ProvinceName] FROM [DOD].[dbo].[View_DPW_PACE]
SELECT MONTH('2014-02-31')
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)