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.
0
Best Answer
-
Try to enter DD?MMM?YY or DD-MMM-YY
It should work if you have first three letters of the month.
1
Answers
-
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,0 -
It is currently not possible to change the format of the date...
0