Formatdate() function got various parameters which can helps us in avoiding replacement path in BEx queries to get date related values like Month Name, Number etc. in Column names.
You can find list of parameters and output in below snapshot. These parameters are not documented in user guides.
Hope this information is helpful.