How to search for DateTime on a table

  • 1
  • Question
  • Updated 3 years ago
I have a table in skuid. It has a date/time field in it. The date time field shows a format like this 

3/17/2015 4:26 pm

What do I need to type into the skuid table search box to find the record with this date/time? 
Photo of Anna Orias

Anna Orias

  • 1,468 Points 1k badge 2x thumb

Posted 3 years ago

  • 1
Photo of Skuidward Tentacles (Raymond)

Skuidward Tentacles (Raymond), Champion

  • 17,224 Points 10k badge 2x thumb
I have had this issue. The date format to search by is 2016-03-03 21:20:59Z
This is inconvenient, so as a work around you can create a formula field like this to search on. It will give you the date in M/D/YYYY format:
text(Month(Datevalue(Sent_At__c)))&"/"& text(Day(Datevalue(Sent_At__c)))&"/"&text(Year(Datevalue(Sent_At__c)))
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
Adding to Raymonds formula.  If you want, you can add this formula field to the search fields,  and not show it in the table.  Then when users search they will get results,  but you can still have the editable date time field shown in your table.