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

Notifications

Announcements

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

    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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#2
SA-08121319-0 Profile Picture

SA-08121319-0 2

#2
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans