Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Human Resources forum / Seniority and Hire Dat...
Human Resources forum

Seniority and Hire Dates not showing correctly in Talent

Posted on by 165

Good Afternoon

I just imported a number of employment dates into Talent. The dates in Talent are off by one day. I've verified the time zone is correct in the set and the correct date shows on the Import file. I remember months ago there was an internal bug with GMT. Does anyone know if this is still the case?

Thanks

Courtney

Categories:
  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Seniority and Hire Dates not showing correctly in Talent

    Hi Courtney, 

    You can use the following for using the time zone conversion in Data Management:

    Navigate to workspace System Administration or via the Hamburger menu:

    pastedimage1562478817046v1.png
    Click on the tile Data management:

    pastedimage1562478822594v2.png

    Click on Configure data Source:

     pastedimage1562478840303v3.png

    Select the data source format you are using for uploading:

     pastedimage1562478856085v4.png

     Set the Time zone preference  to company.

    This will result in a correction based on the:

    1. Legal entity you are logged in while loading, in combination with the
    2. Time zone maintained on the legal entity;

    pastedimage1562478986182v5.png

    When you now complete the upload via Data Management:

    1. Maintain the date field as (for example) ' 01-05-2010 00:00:00' in your data file (Excel);
    2. Upload the file via Data Management, while you are logged in to the legal entity you are loading against (this is needed for the correct timezone to be recognized); 
    3. The date will now be uploaded correctly against the correct time zone;

    Note: When validating the data, make sure to set you user settings also to the same time zone in order to validate if the data is correct.

  • CMSULLIVAN Profile Picture
    CMSULLIVAN 165 on at
    RE: Seniority and Hire Dates not showing correctly in Talent

    Good Morning

    Thank you for responding. You mentioned using the zone conversion in Data Management. Where would I access that? Once you export the employee template, fill out the info, and then reimport. Where can I adjust the time zones? In the export the dates show as correct, but Talent is slightly off.

    Thanks again

    Courtney

  • CMSULLIVAN Profile Picture
    CMSULLIVAN 165 on at
    RE: Seniority and Hire Dates not showing correctly in Talent

    Good Morning

    Thank you for responding. You mentioned using the zone conversion in Data Management. Where would I access that? Once you export the employee template, fill out the info, and then reimport. Where can I adjust the time zones? In the export the dates show as correct, but Talent is slightly off.

    Thanks again

    Courtney

  • CMSULLIVAN Profile Picture
    CMSULLIVAN 165 on at
    RE: Seniority and Hire Dates not showing correctly in Talent

    Good Morning

    Thank you for responding. You mentioned using the zone conversion in Data Management. Where would I access that? Once you export the employee template, fill out the info, and then reimport. Where can I adjust the time zones? In the export the dates show as correct, but Talent is slightly off.

    Thanks again

    Courtney

  • CMSULLIVAN Profile Picture
    CMSULLIVAN 165 on at
    RE: Seniority and Hire Dates not showing correctly in Talent

    Good Morning

    Thank you for responding. You mentioned using the zone conversion in Data Management. Where would I access that? Once you export the employee template, fill out the info, and then reimport. Where can I adjust the time zones? In the export the dates show as correct, but Talent is slightly off.

    Thanks again

    Courtney

  • CMSULLIVAN Profile Picture
    CMSULLIVAN 165 on at
    RE: Seniority and Hire Dates not showing correctly in Talent

    Good Morning

    Thank you for responding. You mentioned using the zone conversion in Data Management. Where would I access that? Once you export the employee template, fill out the info, and then reimport. Where can I adjust the time zones? In the export the dates show as correct, but Talent is slightly off.

    Thanks again

    Courtney

  • CMSULLIVAN Profile Picture
    CMSULLIVAN 165 on at
    RE: Seniority and Hire Dates not showing correctly in Talent

    Good Morning

    Thank you for responding. You mentioned using the zone conversion in Data Management. Where would I access that? Once you export the employee template, fill out the info, and then reimport. Where can I adjust the time zones? In the export the dates show as correct, but Talent is slightly off.

    Thanks again

    Courtney

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Seniority and Hire Dates not showing correctly in Talent

    Hi Courtney,

    I just completed a data upload with one of my customers without any issues for seniority date and hire date.

    I have completed the upload via Data Management, and used the time zone conversion  available their. So not  using the Excel Add-in.

    Please reach out if you still have the issue, and would like to have a quick chat.  

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans