How to update the Date as Blank from import Action

Hi, How can i update a Date Column which already had Valid Date with BLANK from Import Action?

Accepted answers

All comments

You could set up an import that had blank dates and use the option "Clear target prior to import" when setting up your import definition.

If that isn't what you're looking for, perhaps you could provide more context?

2015-08-20_17-08-24_398.png

peter_mcanena

You should also consider creating a date-type line item in that module with the formula BLANK, then save a view with just that line item in it and import from there. That will set all the dates to blank, and will also allow you to fine-tune the affected rows later if necessary.

JosAngel94

@amanda_myton what if i try to do this on a list, which doesn´t have the clear target option?

josephwood

(1) Set up a no data line item in the same module, (2) Import the no data line item into the field you want to clear and have the import set as clear target.

Quick Links

Can you help?

Unanswered questions

Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…