Hi All, I tried to build a query which is: case when t1.date between "31AUG2015"d - 365 and "31aug2015"d then 1 else 0 end but since I have to run this query every month-end. I have to change "31aug2015" to "30sep2015" next month and so ever. Is there any prompt technique to handle this automatically? Thanks a lot
... View more