# Calculating Dates - FileMaker

I have a creation date field. A Approx Time frame field. Then a Approx Finish Date field. I can get it to add the correct amount of days to the creation date but i dont want it to count the weekends. Does anyone have or know the formula i should put in the calculation. Regards Michael....

1. ## Calculating Dates

I have a creation date field.
A Approx Time frame field.

Then a Approx Finish Date field.

I can get it to add the correct amount of days to the creation date
but i dont want it to count the weekends. Does anyone have or know the
formula i should put in the calculation.

Regards Michael.
inzane Guest

2. ## Re: Calculating Dates

In reply to [email]b681fca9.0309032303.60d05da5posting.google.com[/email] on 9/4/03 12:03
AM by inzane [email]inzane2pac-outlawz.com[/email]:

Hi Michael,

Try this one.

creation date + Int(Time frame/5) * 7 +
Middle("12345012340123601256014560345623456", (DayofWeek(creation date) - 1)
* 5 + Mod(Time frame, 5) + 1, 1)

HTH

Lee
> I have a creation date field.
> A Approx Time frame field.
>
> Then a Approx Finish Date field.
>
> I can get it to add the correct amount of days to the creation date
> but i dont want it to count the weekends. Does anyone have or know the
> formula i should put in the calculation.
>
> Regards Michael.
Lee Smith Guest

3. ## calculating dates

Does anyone know if there's an easy way to code (or buy an xTra) that will see if one date is between two others?

Thanks!

frankgrimes webforumsuser@macromedia.com Guest

4. ## Re: calculating dates

You can do math operations with the date object returned by the
systemdate function

put the systemdate
-- date( 2003, 12, 8 )

put the systemdate - date( 2003, 11, 3 )
-- 35
JB Guest

5. ## Re: calculating dates

read this:

[url]http://webforums.macromedia.com/director/messageview.cfm?catid=187&threadid=730192&highligh t_key=y&keyword1=Date[/url]

hope it helps!

On Mon, 8 Dec 2003 21:07:57 +0000 (UTC), frankgrimes
<webforumsusermacromedia.com> wrote:
> Does anyone know if there's an easy way to code (or buy an xTra) that
> will see if one date is between two others?
>
> Thanks!
>
>
>
Christian Grass Guest

6. ## Re: calculating dates

You can make comparisons with the date object:

put date(2003,12,5) < date(2004,1,1)
-- 1

--

Dave
[url]http://www.blurredistinction.com/director[/url]

Dave Mennenoh Guest

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•