Custom Date Format while exporting



Currently I have a grid at a day wise granularity. While exporting the grid the day is shown as follows:

1) As row header [here time is pivoted at a rows] - format comes as '1-Apr-2024'
2) When i bring it as a line item [with formula- ITEM(Time)] format comes as '4/1/2024'

I would like to get a custom format of '20240401' generated so that it can be used for further upload, is there a way i can achieve this ? Or a way to control the settings/format somehow.



Best Answer


  • @Sachinsourav02

    The date format in Anaplan is presented based on user browser settings, which would either be represented as DD/MM/YYYY or MM/DD/YYYY.

    You can convert with the formula however you want, if you want in only numeric format you can do the same. Here is some idea below screenshot.

    Hope it helps ! let me know if you facing any issue.