Is it possible for Anaplan to import data as "date" the format of which is like "28-May-13"?

KOBAYASHI

Hello,

year: 2013
month: 5 (May)
day: 28th

I have already tried the following custom formatting: "dd-mm-yy."

But this did not work out.

Thank you very much in advance.

Accepted answers

KirillKuznetsov

@KOBAYASHI

Try to enter DD?MMM?YY or DD-MMM-YY

It should work if you have first three letters of the month.

All comments

KirillKuznetsov

@KOBAYASHI

Try to enter DD?MMM?YY or DD-MMM-YY

It should work if you have first three letters of the month.

KOBAYASHI

I really appreciate your quick answer.

I tried "DD-MMM-YY" and selected "English" as the language for month name. As a result, the import succeeded, but the format was automatically changed from "28-May-13" to "2013/5/28."

Can I import the date data as it is without changing its format?

Sincerely,

ChrisAHeathcote

It is currently not possible to change the format of the date...

Quick Links

Can you help?

Unanswered questions

Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…
Curious Comparison: Forecast Modeling for Unusual Products
I've been experimenting with some forecast modeling techniques in Anaplan recently and decided to test them on a few quirky, offbeat product categories just for fun. One of the categories I played around with was love dolls—yes, you read that right. It actually turned out to be more interesting than expected. Unlike…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled