Change "DateTime" format into "Date Only" from existing record.

(0) Share

Report

Posted on by Community Member

I have a "DateTime" field and declared the format as Date and Time. But it saves the date as UTC format. when I fetch data in the plugin then it shows the one day back DateTime (UK DateTime).

3554.datetime.png

After few months I changed it to "Date Only" format. Now it picks the local DateTime.

Problem is how to convert DateTime from all record which was created at that time.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

Hi Pawan,

What I understand that you need the date only value instead of date time value. As you are on premise so I would suggest go to the data base and find the entity with the date only field.

You can see the date time column of the field , the difference "datetime and date only " value you will find the time part for date only value is : "12:00 AM" which means those value has been inserted when you made it date only and others value may have full time.

Now for datetime value , you can easily convert with local datetime and you know those value are basically UTC format, convert those value to local datetime and update.

There is built in SQL function by which you can convert to UTC datetime to local date using offset.

Please follow below reference hope you will get help from here.

community.dynamics.com/.../dynamics-crm-datetimes-the-last-word

Please note before doing any update, first try to do some data analysis and try to retrieve the data with changing local date format and check whether those data are as expected as you want and then you execute your final query.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Goutam ,

I am using MSCRM online. I try to fix using following link.

www.inogic.com/.../updating-date-values-of-existing-records-after-modifying-the-datetime-behaviour-in-dynamics-crm-online-update-1

but I do not understand where to write the code.

Was this reply helpful? Yes No
Suggested answer

Temmy Wahyu Raharjo 2,916 on at

Like (0)

Report

Hi, You can create Console Application using this tutorial:

msdn.microsoft.com/.../jj602970.aspx

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

Hi Pawan,

If you are online then create a console application retrieve the date field value using fetchXML or web API and convert it to your local datetime using C# and then update the record again .

Here is sample console application.

community.dynamics.com/.../273478

Was this reply helpful? Yes No