Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to set up current year while loading data

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

1 Solution

Accepted Solutions
settu_periasamy
Master III
Master III

i think, this will also work..

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

View solution in original post

6 Replies
Not applicable
Author

I cannot do this:

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

Not applicable
Author

I am all set!

I can do the one shows above.

sunny_talwar

You got it to work now?

settu_periasamy
Master III
Master III

i think, this will also work..

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

Not applicable
Author

Yes, thank you!

Not applicable
Author

Yes, this works too.