Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

Date only Fields with different default times

Posted on by 335

Hi,

i have various Date Only Fields in the system.  regarding the default time applied to these, some are 00:00:00, and some are 11:59:00.

is this expected behaviour?

*This post is locked for comments

  • Johnny Gong Profile Picture
    Johnny Gong 6,482 on at
    RE: Date only fields have different time values

    Hi Smcconnell,

    You could refer to the following Official description on Date and time field behavior and format. The time portion of the value should always be12:00AM if the date fields are set to date only. Could you share your D365 Version. Is it Online or On Premise?

    technet.microsoft.com/.../dn946904.aspx

    docs.microsoft.com/.../behavior-format-date-time-field

    Best Regards

    Johnny

  • smcconnell Profile Picture
    smcconnell 335 on at
    Date only fields have different time values

    Hi,

    I have several Date Fields which are set to date only.  it appears some of these have a default time setting of 00:00:00, and some have a 11:59:00.

    does anyone know if this is expected behaviour?

  • Suggested answer
    gdas Profile Picture
    gdas 50,085 on at
    RE: Date only Fields with different default times

    Hi,

    If the field format is Date Only then the default time should be 00:00:00 .

    As field format (Date Only, Date and Time) can change any time so it might happen that someone changed the field format with date and time .

  • Verified answer
    David Jennaway Profile Picture
    David Jennaway 14,063 on at
    RE: Date only Fields with different default times

    It depends. If the Behaviour = Date Only, then the time portion should always be 00:00:00. However, if the field has different Behaviour ('User Local' or 'Time Zone Independent') but with the Format = Date Only, then the time portion can differ (if Behaviour = User Local, then it can differ depending on the time zone of the user who saved the record

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,104 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans