Calculating Dates

[inzane]

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]

In reply to [email]b681fca9.0309032303.60d05da5@posting.google.com[/email] on 9/4/03 12:03
AM by inzane [email]inzane@2pac-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.

[frankgrimes webforumsuser@macromedia.com]

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!

[JB]

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

[Christian Grass]

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
<webforumsuser@macromedia.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!
>
>
>

[Dave Mennenoh]

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]