How to set up current year while loading data

[#1]

Hello,

I try to limit my year peroid while loading data. The period I am looking for is from 1990 until current date (let's say 06/07/2016.

I did " WHERE Year (Date) > '1990' "

How can I do set up the second condition and set up the date is equal and less than the current date?

" WHERE Year (Date) > '1990'  and  Date < = ?? "

Thank you,

Becky

[#2]

I cannot do this:

WHERE Year ( [Date]) > '1990' AND Year ( [Date]) < = Year (Now())

[#3]

I am all set!

I can do the one shows above.

[sunny_talwar]

You got it to work now?

[settu_periasamy · Accepted solution]

i think, this will also work..

WHERE Year ( [Date]) > '1990' AND [Date] < = Today();

[#6]

Yes, thank you!

[#7]

Yes, this works too.