This year and last year.

[travismp]

I need to see all values in a date field [SalesDate] for all of this year and all of the previous year.

I know this will show me all of the previous year

Year([SalesDate]) = Year(Date()) - 1

But how do I show all of this year and all of he previous year as well? thanks.

 

[Dennisk]

in a query use The BEWTEEN AND Keywords


e.g. Year(YourDate) BETWEEN Year(Date()) AND Year(Date()) - 1

 

[travismp]

Thank you. I went to add that and I think this will be a little more complicated than I thought. Here is my current SQL vlaue for my query

Switch(([AD_DDate]>=#1/1/2007# And [AD_ADate]>=#1/1/2007#) Or [Approved]=-1,'PASS') AS PASS,

How could I change these two values from 1/1/2007 to current year and previeous year?

 

[raskew]

Hi -

Pass: IIf(Year([YourDate]) Between Year(Date()) And Year(Date())-1,"Pass","")

HTH - Bob

 

[LPurvis]

I'd actually recommend

WHERE [SalesDate] >= DateSerial(Year(Date()) - 1, 1, 1)

If you have future dates too that you needed to exclude then you'd need to add to that
WHERE [SalesDate] >= DateSerial(Year(Date()) - 1, 1, 1) AND [SalesDate] < DateSerial(Year(Date()) + 1, 1, 1)

Assuming we're talking previous calendar year and that last year was 2008 (unless I've been dreaming and it was actually 2007 ;-)

Cheers.