Hi Engin, Couple of questions: 1. What does the query do? (besides a 'case when'; what are you trying to accomplish with the results of the query) 2. When does the query run? (does it always run on the last day of the month? Or also on onther days/dates? 3. What is the reason you're using a prompted value? I believe there are multiple solutions depending on the questions above.
... View more