MONTH converting into number while exporting data to EXCEL

[himabinduch]

Hi All,

i have below monthly field   in script leave which working fine , but while im exporting the same from access point it is converting my month field into number. pleas help me on the same.

dual(mid(FISCAL_MONTH_NAME,12,3),FISCAL_MONTH_NUM) AS DT_FISCAL_MONTH_CRD

[Arthur_Fong · Accepted solution]

Duplicate the month field into 2:

dual(mid(FISCAL_MONTH_NAME,12,3),FISCAL_MONTH_NUM) AS DT_FISCAL_MONTH_CRD,

mid(FISCAL_MONTH_NAME,12,3) as FISCAL_MONTH

Use FISCAL_MONTH at front end table.