My boss has given me a task of modifying the current forms we are using in our Filemaker database.
Attachment explains visually.
One of the things he is trying to do is have two fields populate one field so we can do a range find (dates).
I have attached an example of what I am trying to do. (Word document v. 2016)
The idea is so we can select two dates from a drop down calendar and it will perform the search in the field for us.
Is this possible, I believe I am getting close by putting in a script such as Job complete = Date one & "..." & Date two,
I'm just not sure what else I am missing.