dbTalk Databases Forums  

Need Script to Find Dates for last seven days

comp.databases.filemaker comp.databases.filemaker


Discuss Need Script to Find Dates for last seven days in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Chuck Jernigan
 
Posts: n/a

Default Need Script to Find Dates for last seven days - 10-02-2005 , 06:57 PM






I am using FileMaker 6 (Windows Version)
I have a solution that includes a date field and I need to find all records
entered in the past seven days that have a date in that field.
I have seen entries in the newsgroup where other posters have asked for
scripts for the same problem. I have tried a number of these scripts and I
either get error messages or I can't use the scripts because the specified
function is not available in FileMaker 6.
Can anyone assist me in this problem?
Thanks



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

Default Re: Need Script to Find Dates for last seven days - 10-02-2005 , 09:04 PM






enter find mode

insert calculated result
(SomeDateField - 7) & "..." & SomeDateField

perform find


Reply With Quote
  #3  
Old   
FP
 
Posts: n/a

Default Re: Need Script to Find Dates for last seven days - 10-02-2005 , 09:08 PM



enter find mode

insert calculated result
(Status(CurrentDate) - 7) & "..." & Status(CurrentDate)

perform find


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.