Professional Web Applications Themes

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. #1

    Default 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. #2

    Default 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. #3

    Default 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. #4

    Default 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. #5

    Default 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. #6

    Default 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

Similar Threads

  1. calculating in tables
    By fisherman in forum Macromedia Exchange Dreamweaver Extensions
    Replies: 1
    Last Post: October 23rd, 09:05 PM
  2. Calculating age
    By Tom Thackrey in forum PHP Development
    Replies: 9
    Last Post: June 9th, 08:49 PM
  3. calculating time
    By wally_errrr in forum Macromedia Director 3D
    Replies: 3
    Last Post: May 8th, 09:43 AM
  4. Calculating
    By Andreas Saarva in forum PHP Development
    Replies: 2
    Last Post: February 26th, 05:30 PM
  5. Calculating field in ASP
    By in forum ASP Database
    Replies: 13
    Last Post: January 10th, 01:37 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139