Date Import not working

CommunityMember111277

Hi All,

Need some quick help

I want to import a date from 1 module to another module using Import action, however I'm error as "Invalid date"

Module 1 - 1 line item (date1) | date format> currentperiodstart()

Module 2 - 1 line item (date 2) | date format

Now, when I'm trying to import date from module 1 into module 2, I'm using column line item as shown below

however, there is an error

Can anyone confirm what I'm doing wrong

Thanks

Accepted answers

1636583

Is this sorted @CommunityMember111277 ?

All comments

rob_marshall

@CommunityMember111277

Try selecting the Custom Mapping boolean on the right.

CommunityMember111277

@rob_marshall I tried that option including all mapping options (with separators, fixed positions patterns etc.), but nothing seems to work.

rob_marshall

@CommunityMember111277

Crazy question, but is the source module in the same model as the target? If so, why not use a formula to get the start date?

Dikshant

Do you have a dimension in the source and target modules? Usually, to import something, you need to have a dimension. We cannot import a module with no dimension as source, so we need a list with dummy item in both source and target. Also can you share the screenshot of mappings tab?

CommunityMember111277

@Dikshant The idea was to check whether it can work without any dimensions. I wanted to use it as reference for other modules. I know formula will work, however just wanted to check if it can work wit Import actions w/o any dimensions.

Thanks.

Dikshant

Once you get the data into the module with a dimension, you can then fetch it into a module using a lookup formula from that specific list item. But yes, we cannot import into modules with no dimensions, so this is the workaround.

1636583

Is this sorted @CommunityMember111277 ?

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385