dbTalk Databases Forums  

Finding a Date

comp.databases.filemaker comp.databases.filemaker


Discuss Finding a Date in the comp.databases.filemaker forum.



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

Default Finding a Date - 10-15-2005 , 04:36 PM






I have a field called "Appointment Date" I want to make a script that
will find all appointment dates Greater than or equal to Today. I
tried using set field >= Get Function (current date) it will not let
me use the >= symbol in the script.

Thanks
JC


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

Default Re: Finding a Date - 10-15-2005 , 07:26 PM






Use set field and
"..." & Get(Current Date)


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

Default Re: Finding a Date - 10-15-2005 , 07:36 PM



In article <1129412164.824072.195580 (AT) g44g2000cwa (DOT) googlegroups.com>,
"JC" <jc (AT) jclewis (DOT) biz> wrote:

Quote:
I have a field called "Appointment Date" I want to make a script that
will find all appointment dates Greater than or equal to Today. I
tried using set field >= Get Function (current date) it will not let
me use the >= symbol in the script.

Thanks
JC
When you are using a script to specify a find for a variable, you have
to format the FIND criterion as text, with quotation marks for the fixed
text. In this case, the format would be

">=" & Get(CurrentDate)

--
For email, remove invalid.


Reply With Quote
  #4  
Old   
Matt Wills
 
Posts: n/a

Default Re: Finding a Date - 10-15-2005 , 07:58 PM



JC wrote on (10/15/2005):

Quote:
I have a field called "Appointment Date" I want to make a script that
will find all appointment dates Greater than or equal to Today. I
tried using set field >= Get Function (current date) it will not let
me use the >= symbol in the script.

Thanks
JC
Script:

Perform Find [No Dialog]

In the Find criteria dialog, using the Insert Symbol tab, enter the two
symbols

Quote:
and //
Matt

--



Reply With Quote
  #5  
Old   
Matt Wills
 
Posts: n/a

Default Re: Finding a Date - 10-15-2005 , 08:03 PM



Matt Wills wrote on (10/15/2005):

Quote:
JC wrote on (10/15/2005):

I have a field called "Appointment Date" I want to make a script that
will find all appointment dates Greater than or equal to Today. I
tried using set field >= Get Function (current date) it will not let
me use the >= symbol in the script.

Thanks
JC

Script:

Perform Find [No Dialog]

In the Find criteria dialog, using the Insert Symbol tab, enter the two
symbols

and //

Matt
Nope, sorry:

I meant "the greater than or equal to" symbol.

Isn't it time these compound symbols had their own places on our keyboards?

Matt

--



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.