Announcements
No record found.
Hello,
I have a case where I need to change the effective date in all positions. The date must be filled with the "Available for assignment" date.
I tried to do it with Data Management, but get an error:
Are there any ways, how could I mass-update the records? Maybe X++?
Hi Mantas,
You can achieve via data management too. When you want to change the position details then earlier position needs to adjust based on new position.
For eg.
Position A : 01/01/2022 to 01/11/2022
Position B : 02/11/2022 to Never
In your case, the effective and expiration is same for the position and that does not work. Position tables are date effective. It means when you can this position manually in the system then it adjusts position dates accordingly.
Check reference link.
learn.microsoft.com/.../date-effectivity
Parag Chapre , thanks for the anwer.In Excel, there are two different positions and they're not related.My main task is to find a way to change the effective date value to the same as Available for assignment.
You can write the X++ code and make a date correction according to this link.
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 509 Super User 2026 Season 1
Giorgio Bonacorsi 375
Adis 268 Super User 2026 Season 1
