Help searching time on timestamplist

[chadski021]

I have 3 fields timestamp start, timestamp end and timestamp list ( list of timestamp from start and end ). My problem is when searching a timestamp from the list, It always shows result even it is not included on the list. Ex the timestamplist is.

9/25/2018 9:00 AM
9/25/2018 10:00 AM
9/25/2018 11:00 AM
9/25/2018 12:00 PM
9/25/2018 1:00 PM
9/25/2018 2:00 PM
9/25/2018 3:00 PM
9/25/2018 4:00 PM
9/25/2018 5:00 PM
9/25/2018 6:00 PM
9/25/2018 7:00 PM
9/25/2018 8:00 PM
9/25/2018 9:00 PM
9/25/2018 10:00 PM
9/25/2018 11:00 PM
9/26/2018 12:00 AM
9/26/2018 1:00 AM

but if search 9/26/2018 3:00 AM it always shows a result.

[siroos12]

If the list is stored in a field of the same table, it means that it stores the list on each and every record, therefore performing a find would results showing all records. 

[comment]

43 minutes ago, chadski021 said:

I have 3 fields timestamp start, timestamp end and timestamp list ( list of timestamp from start and end ).

Is the timestamplist field a Text field, containing a return-separated list of timestamp values?

[chadski021]

7 minutes ago, comment said:

Is the timestamplist field a Text field, containing a return-separated list of timestamp values?

this is the custom function i used.

https://www.briandunning.com/cf/440

29 minutes ago, siroos12 said:

If the list is stored in a field of the same table, it means that it stores the list on each and every record, therefore performing a find would results showing all records. 

yes it is a stored field.

[comment]

15 minutes ago, chadski021 said:

this is the custom function i used.

This doesn't answer my question regarding the type of the field (or the type of calculation's result, if it is a calculation field).

Assuming it is text, the rules applied during find will be the rules for finding text and characters and  Filemaker will not recognize the timestamp values as such. Looking at your example, you are searching for three words: "9/26/2018",  "3:00" and "AM" - and all three are present in the found record. If you want to find the exact value "9/26/2018 3:00 AM" you must enclose it in quotes.

Alternatively, you could store the values individually as timestamps in a related table and search there.

But it seems like the best solution would be to search the start and end fields directly. I really cannot see why you need the list.

 

Edited September 25, 2018 by comment

[chadski021]

1 hour ago, comment said:

This doesn't answer my question regarding the type of the field (or the type of calculation's result, if it is a calculation field).

Assuming it is text, the rules applied during find will be the rules for finding text and characters and  Filemaker will not recognize the timestamp values as such. Looking at your example, you are searching for three words: "9/26/2018",  "3:00" and "AM" - and all three are present in the found record. If you want to find the exact value "9/26/2018 3:00 AM" you must enclose it in quotes.

Alternatively, you could store the values individually as timestamps in a related table and search there.

But it seems like the best solution would be to search the start and end fields directly. I really cannot see why you need the list.

 

The field is a stored calculation text field

@comment Thanks i think it resolves my issue by putting enclosed quotes.

[chadski021]

By the way, What is format when searching that has enclosure. Is this correct?  """ & 9/26/2018 3:00 AM & """

[comment]

If you mean how to produce quoted text as a result of a calculation formula, try =

"\"9/26/2018 3:00 AM\""

or =

Quote ( "9/26/2018 3:00 AM" )

 

Edited September 25, 2018 by comment