dbTalk Databases Forums  

Find 30 days in date future

comp.databases.filemaker comp.databases.filemaker


Discuss Find 30 days in date future in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Daniel R. Sloan
 
Posts: n/a

Default Find 30 days in date future - 06-26-2007 , 01:33 AM






I tried this script for current to 30 days or 60 days ahead either, but it
is not working. Can you check this correct or wrong script?

Set Field [ExpiredDate;GetAsText(Get(CurrentDate)) & "..." &
GetAsText(Get(CurrentDate)+30)]

Daniel R. Sloan




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

Default Re: Find 30 days in date future - 06-26-2007 , 02:50 AM






Make sure the field where your find is taking place is of type 'Date'.

Then (in Find Mode) do this script step:

Insert Calculated Result [Select; TheDatabaseName::TheFieldName; Get
( CurrentDate ) & "..." & Get ( CurrentDate ) + 30]


Reply With Quote
  #3  
Old   
Paul Bruneau
 
Posts: n/a

Default Re: Find 30 days in date future - 06-26-2007 , 10:11 AM



On Jun 26, 3:50 am, hbrendel <h... (AT) data33 (DOT) nl> wrote:
Quote:
Make sure the field where your find is taking place is of type 'Date'.

Then (in Find Mode) do this script step:

Insert Calculated Result [Select; TheDatabaseName::TheFieldName; Get
( CurrentDate ) & "..." & Get ( CurrentDate ) + 30]
hbrendel I think your answer is flawed.

Daniel, I think your calculation is correct, it shows up correctly in
my Data Viewer. Make sure you are in find mode and make sure as
hbrendel said that the field is a date field.

To test it youself, put a pause step after your set field so that you
can examine the content of your field "ExpiredDate" while still in
Find mode.



Reply With Quote
  #4  
Old   
Daniel R. Sloan
 
Posts: n/a

Default Re: Find 30 days in date future - 06-26-2007 , 12:47 PM



Finally, I can see, but I hate with or without "pause" I have click "find"
then show view list. How can I can without click find button?


Enter Find Mode[]
Set Field [ExpiredDate;GetAsText(Get(CurrentDate)) & "..." &
GetAsText(Get(CurrentDate)+30)]
Go to Layout ["Database - view as list(data)]


What's next script? without click pause or find button.

PS, I am 2nd language, because I am hearing loss person.

Daniel R. Sloan



Reply With Quote
  #5  
Old   
Howard Schlossberg
 
Posts: n/a

Default Re: Find 30 days in date future - 06-26-2007 , 01:11 PM



Perform Find[]

Daniel R. Sloan wrote:
Quote:
Finally, I can see, but I hate with or without "pause" I have click "find"
then show view list. How can I can without click find button?


Enter Find Mode[]
Set Field [ExpiredDate;GetAsText(Get(CurrentDate)) & "..." &
GetAsText(Get(CurrentDate)+30)]
Go to Layout ["Database - view as list(data)]


What's next script? without click pause or find button.

Reply With Quote
  #6  
Old   
Daniel R. Sloan
 
Posts: n/a

Default Re: Find 30 days in date future - 06-26-2007 , 11:54 PM



Finally, it is beatiful perfect script. Many thanks for help!

Thank you,
Daniel R. Sloan



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.