I’m trying to to display the date from a database table in a date/time picker input. I want the user to be able to see the current date/time and be able to change the date/time if they want to.
I get the below issue when trying to do this:
I am doing a search on the data type “County Settings” with a constraint of “County=Current User’s County” in order to only have one possible row to pull from. But I continue to get the issue stating the content is a List of dates. Here is the County Settings table:
What am I doing wrong here?
A search will always return a list of results (or empty) even if you know the result should be only a single item. A list with one item is still a list. So in your case you current expression returns a list of dates of size 1.
So if you know that your search will always return one item list, you can use the :first item function to get the first item of the list, which in this case is just the only item in your result list.
So in your initial content click on the (More...)
and select :first item

1 Like
@seanhoots thanks so much that worked!