How to add month name/or year to data report?

I can tried using SQL to build a command in connection, but not allow to place it onto the report header, according to the structure.
It there any code in caption that similar to %D to display month, or display year in the header?