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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Date/Time and Time Zones
Microsoft Dynamics CRM (Archived)

Date/Time and Time Zones

(0) ShareShare
ReportReport
Posted on by Jacob Goldstein 95

My organization uses data inside of CRM for eligibility files. We use basic unique identifier data to check eligibility for Services. We have imported a huge number of potential attendees as Leads within the system. Upon import all leads were imported with a Date of Birth. The DOBs were entered with the correct date but a time of midnight. What this means is that when users of our CRM system log in from Central Standard Time they see the DOBs as a day earlier. I have checked the attribute on the Lead form and it is formatted for Date Only but this problem persists.

 I see a potential solution in a Bulk Edit but am wondering if anyone else has an idea?

 Thanks

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Date Only fields in CRM are automatically set to 12:00 AM behind the scenes (Date and Time are also set to 12:00 AM, but you can see this value on the form), and they will display in the user's local time. For example, if the Date field contains "1/1/2010 1:00AM" when uploaded in EST, a user accessing the same record in LA will see "12/31/2009 10:00PM" displayed because the base value is stored in UTC and displayed in the local user's time zone.

    Option 1: Re-import all Leads with Date of Birth set in noon date & time format "XX/XX/XXXX 12:00:00" (e.g. 1/1/2010 12:00:00) to minimize the chances of time zone differences offsetting the original date.

    Option 2: Run a SQL script (in CRM on-premise only with SQL database access) to modify all affected Lead records with Option 1's date & time format (e.g. 1/1/2010 12:00:00)

    Option 3: For all records with same Date of Birth, run Bulk Edit tool to update Date of Birth field with "XX/XX/XXXX 12:00:00" format. This will make all Date of Birth values the same for all records that you select when you run Bulk Edit. Only do this if the Date of Birth values should actually be the same.

     

    Please vote for this answer if it helped you in any way solve your problem.

  • Suggested answer
    ScottDurow Profile Picture
    ScottDurow 23 on at

    I tend to add 6 hrs onto all dates that don't have a time element to minimize this issue. Export to excel and mark for re import is going to be your best option. Then you'll need to add some JavaScript to adjust the time when entered on the form.

    Hope this helps

  • Suggested answer
    ScottDurow Profile Picture
    ScottDurow 23 on at

    I did a blog post about this as well that might help - www.develop1.net/.../Dynamics-CRM-DateTimes-the-last-word.aspx

  • Community Member Profile Picture
    Community Member on at

    Can you use a simply Java Script on the field to correct the date/time issue?

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
ScottDurow Profile Picture

ScottDurow 2

#2
GJones Profile Picture

GJones 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans