dbTalk Databases Forums  

go to a DATE record

comp.databases.filemaker comp.databases.filemaker


Discuss go to a DATE record in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Stephen Larivee
 
Posts: n/a

Default go to a DATE record - 08-11-2010 , 06:28 AM






FMP 11 on WinXP

I have an old script from FMP 5. I would like to update it so it is the way
a script should be with FMP 11. I have a file that has one date per record
and one record for each day over the last several years. It also has
records with future dates. I would like the file to open and then do this:
find all records
sort by date
go to the record with today's date.

Could someone help me with the last line, going to today's date while
showing all records?

The Date field is simply called DATE.

Reply With Quote
  #2  
Old   
Ursus
 
Posts: n/a

Default Re: go to a DATE record - 08-11-2010 , 12:53 PM






The newer versions of filemaker retain sorted order / active record

So perform find on current date
then find all
then sort

The active record still is today

--
Keep well / Hou je goed

Ursus

"Stephen Larivee" <lariveesl (AT) yahoo (DOT) com> schreef in bericht
news:i3u1h5$uae$1 (AT) news (DOT) eternal-september.org...
Quote:
FMP 11 on WinXP

I have an old script from FMP 5. I would like to update it so it is the
way a script should be with FMP 11. I have a file that has one date per
record and one record for each day over the last several years. It also
has records with future dates. I would like the file to open and then do
this:
find all records
sort by date
go to the record with today's date.

Could someone help me with the last line, going to today's date while
showing all records?

The Date field is simply called DATE.

Reply With Quote
  #3  
Old   
Stephen Larivee
 
Posts: n/a

Default Re: go to a DATE record - 08-11-2010 , 03:23 PM



This worked great!!!! Thanks a lot.

"Ursus" <ursus.kirk (AT) ziggo (DOT) nl> wrote

Quote:
The newer versions of filemaker retain sorted order / active record

So perform find on current date
then find all
then sort

The active record still is today

--
Keep well / Hou je goed

Ursus

"Stephen Larivee" <lariveesl (AT) yahoo (DOT) com> schreef in bericht
news:i3u1h5$uae$1 (AT) news (DOT) eternal-september.org...
FMP 11 on WinXP

I have an old script from FMP 5. I would like to update it so it is the
way a script should be with FMP 11. I have a file that has one date per
record and one record for each day over the last several years. It also
has records with future dates. I would like the file to open and then do
this:
find all records
sort by date
go to the record with today's date.

Could someone help me with the last line, going to today's date while
showing all records?

The Date field is simply called DATE.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.