web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Position effective date - mass change

(1) ShareShare
ReportReport
Posted on by 128

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.
pastedimage1667466642877v1.png

I tried to do it with Data Management, but get an error:
pastedimage1667466283575v2.png

Are there any ways, how could I mass-update the records? Maybe X++?

I have the same question (0)
  • Suggested answer
    Parag Chapre Profile Picture
    12,254 Most Valuable Professional on at

    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

  • MÅ -19021417-0 Profile Picture
    128 on at

     Parag Chapre , thanks for the anwer.
    In Excel, there are two different positions and they're not related.
    pastedimage1667474752122v1.png
    My main task is to find a way to change the effective date value to the same as Available for assignment.

  • Verified answer
    Parag Chapre Profile Picture
    12,254 Most Valuable Professional on at

    You can write the X++ code and make a date correction according to this link.

    learn.microsoft.com/.../date-effectivity

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 509 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 375

#3
Adis Profile Picture

Adis 268 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans