How to filter out the year inside current_date

[satay2hot]

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.

[satay2hot]

dont worry just found

extract(year,current_date)
extract(month,current_date)


thanks for helping

[blom0344]

If you want an unique key for period, then define:

extract(year,current_date)*100+extract(month,current_date)

i.e.:  201206