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

Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Berapa nomor Tokopedia?
Tokopedia Menyediakan layanan WhatsApp? Untuk menghubungi layanan Tokopedia melalui (WA)62_08174_9080_16 kamu bisa mengikuti.
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.…