YTD previous year

[jms02360]

Hello,
Im trying to get the prevous YTD to work. The current year to date
works fine.
Projects: Sum(IIf([StartDate] Between
[Forms]![frmRptDateRange/Note].[BeginDate]
And [Forms]![frmRptDateRange/Note].[EndDate],1,0))

Here's the expression for the previous year.
Projects_LY: Sum(IIf([StartDate] Between
DateSerial(Year([Forms]![frmRptDateRange/Note].[BeginDate])
-1,Month([Forms]![frmRptDateRange/Note].[BeginDate]),Day([Forms]![frmRptDateRange/Note].[BeginDate]))

And
DateSerial(Year([Forms]![frmRptDateRange/Note].[EndDate])-1,Month([Forms]![frmRptDateRange/Note].
[EndDate]),Day([Forms]![frmRptDateRange/Note].[EndDate]))
And Year([StartDate])=Year(Date())-1,1,0))

Both have a criteria of >0.

Thanks

 

[Guest]

Try:

SELECT Format$([date],'yyyy') AS [Year]
FROM yourtable
WHERE (((Format$([date],'yyyy'))=Year(Now())-1));