Issue while Importing Dates in week format

Hi All,

I am trying to import data into my module however, i am not able to map the date format with the modules timescale, the date is in "Week 1 FY19" format and i am not sure which time scale format will be suitable for the same.

Thanks.

Accepted answers

Misbah

@sharmagh

If your time format is like "WEEK 1 FY19" then you should keep it as "Match Name" in Import Mapping. Let us know if you are facing any issues with that

Misbah

DmitryP

Hi Sharmagh,

If you navigate to Import settings, you are able to select the format you need either from already excising options OR the custom one, where "?" replace characters which should be ignored - see the screenshot below.

Hope that helps,

Dmitry

All comments

Misbah

@sharmagh

If your time format is like "WEEK 1 FY19" then you should keep it as "Match Name" in Import Mapping. Let us know if you are facing any issues with that

Misbah

DmitryP

Hi Sharmagh,

Hope that helps,

Dmitry

priyankshibisht1

Hi ,
I was doing this training and came across with the same issue .
Tried everything which was discussed above .
But I am still facing the issue in date in week format .
Nothing is working , can anyone help me with resolving this issue ?

PeterZ

The date should be formatted in - periods - custom fixed-position pattern : ???? W ??YY

Note the space must be added in after and before the question mark to match the custom date format otherwise the import won't work.

😅

Quick Links

Can you help?

Unanswered questions

How do I determine why Anaplan API login fails intermittently ?
Hello, My interface uses basic authentication to log in to Anaplan. The login process has been failing intermittently for about a week. How can I identify the root cause of these Anaplan API login failures? Username and password are correct. The account is not locked or expired. Thanks, Jorge Palma
Anaplan XL license issue
Hello , I recently started Anaplan XL course , added XL however not able to add license How to ad license
Error while uploading ADO screenshots
Hello Anaplan Community, I'm facing an issue while uploading ADO screenshots, crosschecked my file size and naming conventions they are correct as mentioned in the lesson. Anyone faced the same issue? Pls let me know how if any solution to this problem. Thank you.