You’re offline. This is a read only version of the page.
5
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...
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.
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?
Kind regards
Wondering...
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
