Working with dates

Need help Database
1

Hi, this is what I am trying to do:

I have a list of dates like this in a db (2018:09:20 07:00 am). Field is called date_ini

I want to extract and show in an input box (for instance (Not available) if the date and hour correspond to a selection in the Date/Time Picker.

I really do not know what is the constraint I need to do. I was trying with merge, unique elements, filtered…

Thanks for your help!!

2

Hi, did you get this working?

How about

search db constrained by date/time picker -> list of matching
search db constrained by date/time picker -> list of not matching

list of matching : formatted to text : find and replace to add (not available)
merge with
list of not matching : formatted to text
filter with a sort