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
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
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?
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 .
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,104 Most Valuable Professional
nmaenpaa 101,156