SQL Aging Report

Hello,

I have a table of current customers that im trying to get an aging report for but is not working correctly.





Current Day
Month To Date
Last Month Same Day

Last Month Total
Last Year to Date

 

here is a sample of what im doing

SELECT

 COUNT(CASE WHEN create_date > dateadd(yy, datediff(year, 1, getdate()), - 365) AND create_date <= DateAdd(year, - 1, DateAdd(day, 0, GetDate())) THEN create_date ELSE 0 END) AS LastYTD,
 COUNT(CASE WHEN create_date > dateadd(yy, datediff(yy, 0, getdate()), 0) AND create_date <= DateAdd(day, + 1, GetDate()) THEN customer_ID ELSE 0 END)  as CurrentYTD

when i add the Current Day sql it gives me the same number as the rest of it which is wrong, it should be 0 based on my date.