Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
i think, this will also work..
WHERE Year ( [Date]) > '1990' AND [Date] < = Today();
I cannot do this:
WHERE Year ( [Date]) > '1990' AND Year ( [Date]) < = Year (Now())
I am all set!
I can do the one shows above.
You got it to work now?
i think, this will also work..
WHERE Year ( [Date]) > '1990' AND [Date] < = Today();
Yes, thank you!
Yes, this works too.