I need help with a filter condition in my WebI report. I have a prompt in my report for Season Year which is in this format "YYYY", and I need to create another filter with this condition.
"Retrieve all the data for which the Object[Year of Expiration Date] (MM/dd/yyy - format) should be equal to season year from prompt."
Can someone please tell me how I can achieve this in WebI, is this something I can apply at query filter level, or do i need to create a variable object for Year of Expiration date and make Year equal to Season year.
Thanks in advance.