Hi everyone ;

 

I'll be very grateful if you can help me on this : I'm keeping all my blood pressure and glucose readings as well as medicine & food intake in FileMaker - all records have a timestamp,and

I would like to know how I can find the records of food or medicine AROUND a certain timestamp,namely if a glucose reading was 180 with a timestamp of ,say, 3/2/2015 10:18:42 how can I find

all records

 

A )  on the same day of this record  

 

B )  five hours BEFORE and AFTER this record.

 

This will help me alot in pinpointing the exact cause of sudden elevations in bp or glucose..

 

I've been trying to copy the said timestamp and enter FIND mode and paste it into the timestamp field,attempting to use " - " and " + " and relevant amount of time in seconds to add to or substract from the pasted timestamp,but all I get is

" The value of this field must be a valid timestamp..."

 

Thank you for your help.

To find records where the date is the same as the date of the current record:
 
Manually:

•  Copy the timestamp value of the current record;
•  Enter Find mode;
•  Paste the copied value back into the timestamp field;
• Delete the time portion of the pasted value;
• Perform Find.

Scripted:

Set Variable [ $date; Value:GetAsDate ( YourTable::Timestampfield ) ]
Enter Find Mode [  ]
Set Field [ YourTable::Timestampfield; $date ]
Perform Find [ ]

---

 

To find records where the timestamp is within the range of a given interval (90 minutes in this example) from the timestamp of the current record:
 
Scripted:

Set Variable [ $timestamp; Value:Table::Timestampfield ]
Enter Find Mode [  ]
Set Field [ Table::Timestampfield; Let ( interval = Time ( 1 ; 30 ; 0 ) ; $timestamp - interval & ".." & $timestamp + interval ) ]
Perform Find [ ]

---

P.S. Please show some consideration to the people trying to help you: spend a bit of time and effort to make your posts readable.

THANK YOU SO MUCH

 

I AM SINCERELY GRATEFUL AND I DO APOLOGIZE FOR THE OVERSIGHT  

 

HAVE A GREAT WEEKEND.

You're welcome. "Readable" does not mean ALL CAPS - on the contrary.

LOL, happiness gone wild.