Jump to content

Using Timestamp in Find


julien177
 Share

This topic is 2852 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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.

Link to comment
Share on other sites

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.

  • Like 1
Link to comment
Share on other sites

This topic is 2852 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.