Johnny R

Johnny R

About

Username: Johnny R
Joined: August 2006
Visits: 0
Last Active: May 2019
Roles: Members

Comments

Getting a bit closer. IF I change my SQL statement to the following ... SELECT FORMAT(Invoices.InvoiceDate,'mmmm') AS [Month], FORMAT(Invoices.InvoiceDate,'yyyy') AS [Year], SUM(Items.ItemIncTax) AS ItemIncTax FROM Invoices INNE…

in Formatting Dates - Feb 05 is actually Jan 05 Comment by Johnny R October 2007