Custom Date Format while exporting
Anaplanners
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.
Thanks
Best Answer
-
Hi
custom format of '20240401' can be generated in text format as shown in screenshot.
In terms of time period Anaplan supports only DD/MM/YYYY. If you are uploading csv file for import you can do the custom mapping in TIME Mapping tab instead of changing time setting in Anaplan.
1
Answers
-
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.
1
