Hi I have been trying to crack my head trying to get the current_date in framework manager only to extract the year portion. Will be nice to filter out the month too.
dont worry just found
extract(year,current_date)
extract(month,current_date)
thanks for helping
If you want an unique key for period, then define:
extract(year,current_date)*100+extract(month,current_date)
i.e.: 201206