Notifications
Announcements
No record found.
Hi all!
I'm looking for a way to import a blank date that overwrites the current placed date in AX.
Any ideas?
Thank you!
Kind regards
Wondering...
Import how?
"Blank date" is actually 1.1.1900 00:00:00 UTC so try to import that value.
Hi Nikolaos,
Thank you for the fast response.
The importation to AX is done by using "Dropzone", with format CSV (Excel).
When importing the suggested format 1900-01-01 (00:00:00), I get the error response that the date is an invalid format, YYYY-MM-DD is the allowed format and the import is therefore cancelled.
We have put up a grid that dates in the importation cannot exceed 7 days back in time and 90 days ahead, to secure wrongful dates is not imported. But by excluding the date 1900-01-01 in this perimeter, this should in theory blank out the dates we want to remove?
If the date format should be YYYY-MM-DD you should of course provide it in that format.
So, that would be 1900-01-01.
Please try with that.
And yes, if you have some validation rules regarding the date import, the rules have to be set up to allow 1900-01-01 to be imported.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 664 Most Valuable Professional
André Arnaud de Cal... 522 Super User 2025 Season 2
Sohaib Cheema 303 User Group Leader
