Timestamp format 12/31/4000 11:59:59.999999 PM in FM13

Discussion created by Boutsy on Aug 4, 2014
Latest reply on Aug 19, 2014 by jormond



In Filemaker 13 The minimum and maximum values of a timestamp are 1/1/0001 12:00 AM and 12/31/4000 11:59:59.999999 PM.

This is usefulle if you want Timestamps to be different when using Get(CurrentTimestamp). Now, when to users use a script with Get(CurrentTimestamp), within the same second, the timestamp is the same and a Find action will give 2 results. I cannot find where to specify how many decimals have to be shownn(or used but not shown) in a TimeStamp Field. Using the format Decimals with a fixed number of decimals will not change the field.

Furthermore I noticed that if the timestamp ends on 00 seconds, when using a find request it wil give all records with the timestamp ending with00 till 59!!!

Example : If you make a search in a timestamp field with 12/31/2014 11:05:00, the result will give all the records from 12/31/2014 11:05:00 till 12/31/2014 11:15:59. So all the records within the same minute!!!! I don't find a way to resolve this problem (f.e.: ==12/31/2014 11:05:00 will also give the same result!!!).


Can somebody please help me?


Thank you,