Changing header with formula using internal clock Crystal 8.5

[envirodata]

Is it possible to change the text object in the header area to display a month prior to the month in the internal clock? For example, I would like the header to read 'May Foundation and Restricted Gifts' this month but next month to read 'June Foundation and Restricted Gifts'. Thank you!

 

[lbass]

monthname(month(dateserial(year(currentdate),month(currentdate)-1,1))) +' Foundation and Restricted Gifts'

-LB

 

[envirodata]

Wow! Thank you!