Filter on Date Time field in Record

I've seen the questions around filtering on date/time field.  Is there a way to change the value within the filters being applied so that it reads the date from the date/time field and filters on that?

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer

    Please keep in mind that date/time fields do down to milliseconds.,so if you really did want to ever even query by a date/time, you should use a view to truncate it to at least minutes, but hopefully hours. Then, in this case, you are no longer querying really by date and time. Does that make sense?

    So, when you have those kind of requirements, try to plan for other data capture alternatives to support more filtering.

Reply
  • 0
    Certified Lead Developer

    Please keep in mind that date/time fields do down to milliseconds.,so if you really did want to ever even query by a date/time, you should use a view to truncate it to at least minutes, but hopefully hours. Then, in this case, you are no longer querying really by date and time. Does that make sense?

    So, when you have those kind of requirements, try to plan for other data capture alternatives to support more filtering.

Children
No Data