Microsoft Dynamics CRM (Archived)

Birthdate field behaving different

(0) Share

Report

Posted on by omgcrm

2,585

Hello Folks,

I have this weird issue.

CRM version : 8.1.0.359 It is an On-Premise version

some of the contacts in CRM have been updating recently. A quick look in the Audit history revelaed the Birthdate field is getting updated.

example :

before 22/10/1988 12:00am

after 22/10/1988 1:00 pm

I have tried disabling the plugins on contact, checked the server sync, checked the integrations but all in vain. I am still unable to find what's causing the birthdate to change.

1) would changing the birthdate from "user local" to "date only" help? (CRM is in NZ timezone)

2)are there any other ways to check what's causing the birthdate to jump?

Thanks!!!!

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (1)

Suggested answer

RaviKashyap 55,410 Moderator on at

Like (1)

Report

Hi,

You need to first find the reason of why this has happened and if this is happing on a consistence basis? If yes, what is the trend of the update. With respect to timezone, for BirthDate, it makes more sense to have it as date only irrespective of the issue. Check the date of the update and see if these are on the same time duration, if yes then this could be related to some bulk update happened.

You need to find if this is still happening or not, if yes then when exactly this happens.

Hope this helps.

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (1)

Report

Not sure what is the reason , but ideally birthdate field should be date only format to avoid time related issue.

Was this reply helpful? Yes No
Suggested answer

Sreevalli 3,256 on at

Like (1)

Report

Hi,

If you are seeing date change only on form but not in audit that means users time zone changed and it will reflect on form. but when you seeing changes in DB level or audit then there is a background thread running to update the date.

If you see the the time getting added by 13hrs every time then you check the timezone changes and the triggers for the same.

Microsoft recommendation for Birthday fields behaviour is DateOnly. https://docs.microsoft.com/en-us/dynamics365/customer-engagement/customize/behavior-format-date-time-field but as you want to change now, check the values before. if all of your old values are 12AM and now its 1PM then its obsolutly works,but if there is a case like old vlaue is 1PM and updated value is 2AM next day then you will end up with issues.

Was this reply helpful? Yes No
omgcrm 2,585 on at

Like (1)

Report

Hello @Sreevalli Balleda

The birthdate getting updated is shown in Audit history. I cant seem to find any process which is updating the birthdate. I have checked the plugins/workflows and disabled them as well.

is there any other way which we can find whats causing this update?

Was this reply helpful? Yes No
omgcrm 2,585 on at

Like (1)

Report

Can we use fiddler to see what has been updating the contact record?

Was this reply helpful? Yes No
Suggested answer

Adrian Begovich 1,027 Moderator on at

Like (1)

Report
Hi Sreekanth P,

A couple questions to ask yourself.

Do Business Rules, JavaScript, Plugins, or Workflows modify the birthdate field?

Does Data Integration or Data Migration modify the birthdate field?

What user is changing the birthdate field in the Audit Log?

When is the change to the birthdate field occurring?

I hope this helps you to narrow down the cause of the issue.

Was this reply helpful? Yes No
Suggested answer

Sreevalli 3,256 on at

Like (1)

Report

Hi Again!

What is your Birthday date entry, is it Manual? or with some input method?

tip, just to confirm if it from serverside or manual updates, just remove the field from form so that any JS or BR will not work on it. then you can further dive down based on audit logs

Was this reply helpful? Yes No
Verified answer

omgcrm 2,585 on at

Like (0)

Report

Hello guys,

Finally, figured the source of the problem.

Setting the mailbox sync for "Appointments, contacts and tasks" to NONE has stopped the update on birthdate field.

Very weird.

Any clue about this?

Thinking to raise an MS Support request as office 365 settings are fine.

Thanks All!!! :)

Was this reply helpful? Yes No
RaviKashyap 55,410 Moderator on at

Like (0)

Report

Not sure but could be related to timezone difference between user's outlook/mailbox and user's CRM timezone.

Worth raising it with Microsoft to get the confirmation. Also, do share response from Microsoft here and mark you response as verified to help other facing the same issue :)

Was this reply helpful? Yes No
Suggested answer

Sreevalli 3,256 on at

Like (0)

Report

Hi Sreekanth,

Good to hear that you found RC :)

I think it because of timezone difference issue between CRM and the user mailbox on Mobile/Tab/Web.

Keep posting MS suggestions. Thanks

Was this reply helpful? Yes No