Location:  Forum Index » Database Schema & Business Logic » Calculation Engine (Define Fields) » Creating Date Range using a Calculation



334 Views    -    4 Replies


Username Post: Creating Date Range using a Calculation        (Topic#215905)
Your continued generosity and support of FMForums is greatly appreciated.
Matt Leach 
apprentice
 Posts: 101

Loc: Spring Hill, FL
Post Rank (AVG):
            


FMP: 11 Advanced
OS: Windows 7

Member: TechNet



Tweet This! Tweet This Post!
07-28-10 09:59 AM - Post#361643     - Post Rank:             


Im working on scripting a report and i want to perform a find on a specific field to include a date range.

Im having some difficulties on how to perform the find to include a date range in the calculation.

Basically what i am trying to do is pull the report to include everything for the next 3 days:

Get ( CurrentDate ) ... Get ( CurrentDate ) + 3

Entering this calculation appears invalid.

What would be the proper way to calculate this?

Thanks










Lee Smith 
*$ time
 Posts: 8389
Lee Smith

Loc: Woodland - Sacramento, CA...
Post Rank (AVG):
            


FMP: 11 Advanced
OS: Mac OS X Snow Leopard

Member: TechNet
Skill: Advance



Tweet This! Tweet This Post!
07-28-10 12:01 PM - Post#361654     - Post Rank:             
    In response to Matt Leach

Are you scripting this, or entering a range in a date field

Read about "Finding ranges of information" in the Online help

and this
Link

Lee










Lee Smith 
*$ time
 Posts: 8389
Lee Smith

Loc: Woodland - Sacramento, CA...
Post Rank (AVG):
            


FMP: 11 Advanced
OS: Mac OS X Snow Leopard

Member: TechNet
Skill: Advance



Tweet This! Tweet This Post!
07-28-10 12:08 PM - Post#361657     - Post Rank:             
    In response to BruceR

You talking to me?

If not, then get in a habit of using the Reply button in the post rather than the Quick Reply Button.










Matt Leach 
apprentice
 Posts: 101

Loc: Spring Hill, FL
Post Rank (AVG):
            


FMP: 11 Advanced
OS: Windows 7

Member: TechNet



Tweet This! Tweet This Post!
07-28-10 12:25 PM - Post#361665     - Post Rank:             
    In response to BruceR

Thank you very much, it seems i always have an eye for overlooking the simplest things lol.

thanks again










Your continued generosity and support of FMForums is greatly appreciated.
BruceR 
Pooh-Bah
 Posts: 2218

Loc: Redmond WA
Post Rank (AVG):
            


FMP: 11 Advanced
OS: Mac OS X Snow Leopard

Member: TechNet
Skill: Expert

Certified:
     

DBUG SIG

Tweet This! Tweet This Post!
07-28-10 12:25 PM - Post#361666     - Post Rank:             
    In response to Matt Leach

Yes, the calculation is invalid. You have not quoted the text string ...
This works:

Get ( CurrentDate ) & "..." & Get ( CurrentDate ) + 3

(Sorry Lee; generally I *am* in the habit of hitting reply but missed it this time)

Edited by BruceR on 07-28-10 12:35 PM. Reason for edit: No reason given.










Icon Legend Permissions Topic Options
Print Topic

Email Topic

334 Views
Welcome Guest...
Enter your username and password to login. If you do not have a username you can register one here

Username

Password

Remember me. Help



Forgot Password...


Quick Links
Recent Posts
Active Topics
No Replies
Recent Files
Functions & Scripts
FileMaker Pro Help
FileMaker on Twitter
FileMaker Marketplace

Custom Search

Find FileMaker Developers

Don't have time to wait,
hire a developer now!
Recent Members
Welcome them to our community!
Find FileMaker Jobs

Want a new career?
Find your new job now!
Joy of Tech
Latest Joy of Tech!

Recent Topics
Recent Hot Topics
Contribute
With your generosity we can make some real magic happen!. Support your favorite online FileMaker community...
FM Forums.com


Click here...

Or a Donation of any amount.


Thanks for your support!

Active Blogs
0 Recent blogs:
People to Post Lately in this Topic
Matt Leach
Lee Smith
BruceR
Location:  Forum Index » Database Schema & Business Logic » Calculation Engine (Define Fields) » Creating Date Range using a Calculation
FM Forums Advertisers


FusionBB™ Version 3.0 FINAL | ©2003-2010 InteractivePHP, Inc.
Execution time: 0.254 seconds.   Total Queries: 72   Zlib Compression is on.
All times are . Current time is 01:43 PM
Content ©1996-2008 Ocean West Consulting, Inc. All Rights Reserved
Ocean West Consulting, Inc. can not and will not be held responsible for any of the contents in this site.
FM Forums™ is a trademark of Ocean West Consulting, Inc an independent entity, not affiliated with FileMaker Inc.
FileMaker® is a registered trademark of FileMaker Inc.
Top