dbTalk Databases Forums  

Finding Dates in FM6

comp.databases.filemaker comp.databases.filemaker


Discuss Finding Dates in FM6 in the comp.databases.filemaker forum.



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

Default Finding Dates in FM6 - 11-15-2006 , 10:22 AM






I have become accustomed to the conveniences of finding in FM8, and have
apparently forgotten everything I knew about FM6. I have been asked to
modify an existing solution in 6.

Someone (Harry?) please refresh me on how I would script finding a range
of dates using global date fields representing StartDate and EndDate and
symbols.

Matt

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

Default Re: Finding Dates in FM6 - 11-15-2006 , 10:31 AM






Make sure the field you're searching on is on the current layout, and
use the Insert Calculated Result step:

datetotext(StartDate) & "..." & datetotext(EndDate)


Matt Wills wrote:
Quote:
I have become accustomed to the conveniences of finding in FM8, and have
apparently forgotten everything I knew about FM6. I have been asked to
modify an existing solution in 6.

Someone (Harry?) please refresh me on how I would script finding a range
of dates using global date fields representing StartDate and EndDate and
symbols.

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Professional Solutions, Inc. Los Angeles

FileMaker 8 Certified Developer
Associate Member, FileMaker Solutions Alliance


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

Default Re: Finding Dates in FM6 - 11-15-2006 , 04:13 PM



I thought I had tried that, but did it again to make sure.

For some reason, all that's being inserted is the ellipsis.

Matt

In article <12lmg6r3mi27df5 (AT) corp (DOT) supernews.com>,
Howard Schlossberg <howard (AT) antispahm (DOT) fmprosolutions.com> wrote:

Quote:
Make sure the field you're searching on is on the current layout, and
use the Insert Calculated Result step:

datetotext(StartDate) & "..." & datetotext(EndDate)


Matt Wills wrote:
I have become accustomed to the conveniences of finding in FM8, and have
apparently forgotten everything I knew about FM6. I have been asked to
modify an existing solution in 6.

Someone (Harry?) please refresh me on how I would script finding a range
of dates using global date fields representing StartDate and EndDate and
symbols.

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

Default Re: Finding Dates in FM6 - 11-15-2006 , 04:45 PM



Are your StartDate and EndDate fields truly dates? Or could they be
text fields?

Matt Wills wrote:
Quote:
I thought I had tried that, but did it again to make sure.

For some reason, all that's being inserted is the ellipsis.

Matt

In article <12lmg6r3mi27df5 (AT) corp (DOT) supernews.com>,
Howard Schlossberg <howard (AT) antispahm (DOT) fmprosolutions.com> wrote:

Make sure the field you're searching on is on the current layout, and
use the Insert Calculated Result step:

datetotext(StartDate) & "..." & datetotext(EndDate)


Matt Wills wrote:
I have become accustomed to the conveniences of finding in FM8, and have
apparently forgotten everything I knew about FM6. I have been asked to
modify an existing solution in 6.

Someone (Harry?) please refresh me on how I would script finding a range
of dates using global date fields representing StartDate and EndDate and
symbols.
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Professional Solutions, Inc. Los Angeles

FileMaker 8 Certified Developer
Associate Member, FileMaker Solutions Alliance


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

Default Re: Finding Dates in FM6 - 11-15-2006 , 05:30 PM



They are dates, but I realized that I had neglected to make them global
dates. There was nothing to insert but an ellipsis.

It works now.

Thanks.

Matt

In article <12ln67udibclie0 (AT) corp (DOT) supernews.com>,
Howard Schlossberg <howard (AT) antispahm (DOT) fmprosolutions.com> wrote:

Quote:
Are your StartDate and EndDate fields truly dates? Or could they be
text fields?

Matt Wills wrote:
I thought I had tried that, but did it again to make sure.

For some reason, all that's being inserted is the ellipsis.

Matt

In article <12lmg6r3mi27df5 (AT) corp (DOT) supernews.com>,
Howard Schlossberg <howard (AT) antispahm (DOT) fmprosolutions.com> wrote:

Make sure the field you're searching on is on the current layout, and
use the Insert Calculated Result step:

datetotext(StartDate) & "..." & datetotext(EndDate)


Matt Wills wrote:
I have become accustomed to the conveniences of finding in FM8, and have
apparently forgotten everything I knew about FM6. I have been asked to
modify an existing solution in 6.

Someone (Harry?) please refresh me on how I would script finding a range
of dates using global date fields representing StartDate and EndDate and
symbols.

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.