Skip to main content
Nintex Community Menu Bar
Question

How to search for DateTime on a table

  • July 10, 2024
  • 2 replies
  • 7 views

Forum|alt.badge.img+7

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? 

2 replies

Forum|alt.badge.img+17

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


Forum|alt.badge.img+17
  • Nintex Employee
  • July 10, 2024

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.