you might have to use `ADD_MONTHS((LAST_DAY({today...
# general
k
you might have to use
ADD_MONTHS((LAST_DAY({today})+1),-1)