Hello Guys,
I am facing a issue that the date time field in the form is being saved wrongly in the database and the server is configured at CST time zone.
So how can i manage it on the code level so that i will be able to save the actual date which i am passing from the UI. And i don't want to change in the CRM like behavior of the field.
Server is at CST Time Zone and i am passing Date from IST.
A great help will be much appreciated.
Thanks
Shashikant Saxena
*This post is locked for comments
Hi,
The datetime field are always stored in UTC time zone in database. These are than converted into users local/configured time zone. So if IST users enters a date, it will be saved as UTC in database. For a CST user, the UTC date time will then be converted from UTC to CST. If you want to save the date time as is then you need to change the behaviour of the date to Timezone Independent.
So even if you manipulate the date using code & timezone. It will still be saved based on the selecte behaviour of the field.
You can read more about this here: www.magnetismsolutions.com/.../introduction-to-behaviours-of-date-and-time-fields-in-dynamics-365
Hope this helps.
Thanks for the response,
I have already tried this approach but it does not work for me.
Hi,
You can use TimeZoneInfo class
TimeZoneInfo targetZone = TimeZoneInfo.FindSystemTimeZoneById("Central Standard Time");
DateTime newDT = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, targetZone);
Check links below hope it helps.
stackoverflow.com/.../creating-a-datetime-in-a-specific-time-zone-in-c-sharp
www.codeproject.com/.../How-can-i-get-CST-Central-Standard-Time-in-asp-net
Thanks,
Ridhima
#1
Mohamed Amine Mahmoudi
83
Super User 2025 Season 1
#2
Community Member
52
#3
Victor Onyebuchi
6
Share
Report
All responses (
Answers (
