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

Accepted answers

SriNitya

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.

https://help.anaplan.com/convert-between-data-types-1a1ac604-62d2-4288-abaa-55fd8e2ee8e2

https://community.anaplan.com/discussion/3539/dates-format

All comments

jagadishdash

@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.

SriNitya

https://help.anaplan.com/convert-between-data-types-1a1ac604-62d2-4288-abaa-55fd8e2ee8e2

https://community.anaplan.com/discussion/3539/dates-format

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…