web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

User Local Date Field not showing Today's Date

(0) ShareShare
ReportReport
Posted on by 1,799

Hi, 

In a blank out of the box test system, I have created two custom Date Fields on an Opportunity: setting behavior type on one of the date Fields to 'User Local' and the other Field to 'Date Only'. 

If I put today's date in both fields on a Record and then do an advanced find to show Records that have a the Date Only field populated in the 'next 24 months' this pulls up all Records. However, If I perform the same Advanced Find query for the User Local field it pulls up every Record BUT the Record that I set the date to today. 

Why does the User local Behavior omit today's Records, whilst the Date Only field includes today's Records. 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    on at
    RE: User Local Date Field not showing Today's Date

    I assume your base settings and personal settings are the same and it is not just a datetime issue. In the UK we find that we have issues with BST and need to work with UTC dates. Can you change the field to store date and time and see what is being stored. Are you on prem or online. If on prem have a look in the sql db to see the data stored.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Aric Levin - MVP Profile Picture

Aric Levin - MVP 2 Moderator

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#3
MA-04060624-0 Profile Picture

MA-04060624-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans