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, ...
Suggested Answer

display method in past worker x++

(0) ShareShare
ReportReport
Posted on by 169

I need to add this display method to get the last termination date (end date) of this worker but this select statement get last line I updated on it ,

so what is wrong in this select ?

Screenshot-_2800_279_2900_.png

Screenshot-_2800_280_2900_.png

it display date 3/8/3018 but I need to display 16/1/2019 How can I fix this in select ?

  • André Arnaud de Calavon Profile Picture
    308,173 Super User 2026 Season 2 on at

    Hi Menna,

    The HcmEmployment table is also enabled for date effectiveness. You can try to add the ValidTimeState command also on line 48.

  • Menna Allah Ahmed Profile Picture
    169 on at

    without maxof (validTo) ?

  • Menna Allah Ahmed Profile Picture
    169 on at

    I got this error how can I write this ?

  • GirishS Profile Picture
    27,845 Moderator on at

    Hi menna,

    Remove validTimeState keyword. It will be enough to add one validTimeState and that to at the start of select statement. It applies for all the tables in the joins.

    Thanks,

    Girish S.

  • Suggested answer
    Mohit Rampal Profile Picture
    12,573 Moderator on at

    Hi Menna, There is already standard method for it in HcmWorkerHelper class. You can get TransitionDate from this HcmEmployment table.

  • GirishS Profile Picture
    27,845 Moderator on at

    You can do one thing. There will be a query named HcmWorkerListPage_PastWorkers - Use that query to create a view - You can use that view to get all the details of past worker and you can use it in future purpose also.

    Thanks,

    Girish S.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 282 Super User 2026 Season 2

#2
Aayush Tiwari Profile Picture

Aayush Tiwari 219

#3
Subra Profile Picture

Subra 211 Super User 2026 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans