Sometimes it can be difficult to get the name of a month from the data, e.g. Jan, Feb etc. One method that works is to use the following code:
substring('Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec', month( _add_months(current_date,-6))*4-3,3)
In that example, the calculation is going back 6 months and getting the month name from the fixed string.
substring('Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec', month( _add_months(current_date,-6))*4-3,3)
In that example, the calculation is going back 6 months and getting the month name from the fixed string.