Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

MSCRM 2011 Date fields time format

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello all,

              I have a requirement that based on date reported datetime input filed i need to send email notifications to users on hourly basis by using time in the date reported field. But time in input datetime fileds are storing in different manner i am  not able to get what time zone it is. The default CRM fields createdon and modifiedon are storing in UTC format only. How can i achieve this using custom input datetime field. Please help me in this.

Thanks

Satish

*This post is locked for comments

  • Suggested answer
    Nithya Gopinath Profile Picture
    Nithya Gopinath 17,076 on at
    RE: MSCRM 2011 Date fields time format

    Hi Satish,

    You can edit your field as follows where you can select Time Zone Independent or User Local. Refer link below:

    https://technet.microsoft.com/en-us/library/dn946904.aspx

    4863.6.PNG

    Hope it helps.

    Thanks

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: MSCRM 2011 Date fields time format

    Hello Satish Kumar,

    Refer this link:

    You can change it to "Date only", "User Local" , "Time-zone Independent" in the "Behaviour option" as shown in this link :

    www.inogic.com/.../handling-datetime-fields-in-microsoft-dynamics-crm-update-1
    "Behaviour" option is a new settings option from Dynamic CRM 2015 Update 1.

    Hope this helps :) Thank you

    Please do verify if you find it helpful :)

  • Suggested answer
    Nithya Gopinath Profile Picture
    Nithya Gopinath 17,076 on at
    RE: MSCRM 2011 Date fields time format

    Hi Satish,

    Please refer the links for converting CRM Date Time to Server Local Time and some facts about CRM Date Time.

    http://www.magnetismsolutions.com/blog/paulnieuwelaar/2012/05/11/convert_dynamics_crm_2011_datetime_to_server_local_time_in_a_plugin

    http://www.powerobjects.com/2012/06/07/crm-2011-truths-about-datetime/

    Hope it helps.

    Thanks

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,387 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans