Anaplan: Valid To period - 9999

Hi Expert,

Good day!

Would like to seek your insights on how to upload the ValidTo period as 12/31/9999 and in Anaplan it will become blank (Date format). Since in Anaplan unable to load this period format unless set the format as text. Is there any workaround to handle this one or a system limitation? Thank you in advance.

Regards,

Dom

Period_-_9999_113208.xlsx

Accepted answers

anand.shekhawat

Hi @dominic.literal

Anaplan has a maximum limit to date that you can enter in the date formatted line item and that is set to 2399-12-31 . You cannot put any date beyond this. You only have one option to store your 'valid to period' (12/31/9999) i.e. text. You can call it as a limitation.

I hope it helps

~Anand

All comments

anand.shekhawat

Hi @dominic.literal

I hope it helps

~Anand

paul_gibson

Can you give some insight on what use case needs this as a year?

dominic.literal

@paul_gibson

Hi,

Thanks for your reply.

The use case is Pricing Simulation. As we agreed with the client, we used the 12/31/2399 as default date. Thank you.

Regards,

Dom

dominic.literal

@anand.shekhawat

Hi,

Thanks for your input.

As we agreed with the client, we used the 12/31/2399 as default date for 12/31/9999. Thank you.

Regards,

Dom

kartiendasolventoph

I am having error in date "1899-12-31" does anaplan accept this?

aduesing

@paul_gibson I do have another case where we receive SAP data where the End Date is filled with 12/31/9999 in case there is no end date yet (in this case for positions).

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