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

KOBAYASHI
Contributor

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

Hello,

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
KirillKuznetsov
Certified Master Anaplanner

Re: Is it possible for Anaplan to import data as "date" the format of which is like "

@KOBAYASHI 

 

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

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

View solution in original post

3 REPLIES 3
KirillKuznetsov
Certified Master Anaplanner

Re: Is it possible for Anaplan to import data as "date" the format of which is like "

@KOBAYASHI 

 

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

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

KOBAYASHI
Contributor

Re: Is it possible for Anaplan to import data as "date" the format of which is like "

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
Community Boss

Re: Is it possible for Anaplan to import data as "date" the format of which is like "

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

Chris
HeathcoteAndHerran.com