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)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.