Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.