UI DateTime Field date search

  • 1
  • Question
  • Updated 3 years ago
  • Answered
I have UI field that is in DateTime format.  I have set up a date filter on a table with auto generated conditions.  I select a date range that should show no results.  However, all records are returned. 
Photo of Bill Fox

Bill Fox

  • 7,934 Points 5k badge 2x thumb

Posted 3 years ago

  • 1
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
Is your field  a "UI Only field" that is only present in your model and not in the sf database?   If so can you post a picture of its configuration?

Thx 
Photo of Bill Fox

Bill Fox

  • 7,934 Points 5k badge 2x thumb
It is UI Only Field that is the result of an if statement from 2 sf date time fields
(Edited)
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
You cannot use a UI only field as a condition.   Conditions run SOQL on the server, and the UI only field never makes it back to the server. 
Photo of Bill Fox

Bill Fox

  • 7,934 Points 5k badge 2x thumb
Got it.  Thanks