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