Professional Web Applications Themes

Search Birthday Date in 30 days future without year - FileMaker

If you were to think in English (I'm assuming that English is your primary language) about what you really want, isn't it that you want to know when their next borthday is. Or more to the point, whose next birthday is in the next 30 days. So what is the continued...

  1. #1

    Default Re: Search Birthday Date in 30 days future without year

    If you were to think in English (I'm assuming that English is your
    primary language) about what you really want, isn't it that you want to
    know when their next borthday is. Or more to the point, whose next
    birthday is in the next 30 days.

    So what is the next birthday? If the data has already passed this year,
    then the date will be next year. Otherwise, the date will be sometime
    between now and the end of the year.

    To translate the english into FileMaker, create a calculation field that is:

    if(
    date(month(Birthday), day(birthday), year(status(currentdate))) <
    status(currentdate),
    date(month(Birthday), day(birthday), year(status(currentdate))+1),
    date(month(Birthday), day(birthday), year(status(currentdate))
    )

    Now use your script with the (-30) and everything to find what you want
    based on this new calculation.



    Daniel R. Sloan wrote:
    > How can I change this date without year? for sample search in 30 days
    > 7/23/x as today between 8/23/x in Birthday date field
    >
    > --------------------------------------------Field Name
    >
    > ExpiredDate Date Indexed
    > gDaysFuture Globe Number
    > ExpiredDate_c Calculation Indexed, = ExpiredDate (X) Do not
    > evaluate if all referenced fields are empty Index = On
    >
    > --------------------------------------------Script - "Days in the Future"
    >
    > Set Error Capture (On)
    > Enter Find Mode ()
    > Set Field ("ExpiredDate_c",Status(CurrentDate) & "..." &
    > (Status(CurrentDate) + gDaysFuture)")
    > Perform Find ()
    > If ("Status(CurrentFoundCount) >= 1")
    > Go to Layout ('List View")
    > Else
    > Show Message ("No Records Found")
    > Find All
    > End If
    > -------------------------
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Howard Schlossberg (818) 883-2846
    FM Pro Solutions Los Angeles, California
    Associate Member, FileMaker Solutions Alliance

    Howard Schlossberg Guest

  2. #2

    Default Re: Search Birthday Date in 30 days future without year

    Success, how about Sort - Month / Day without year?

    Daniel R. Sloan


    Daniel R. Sloan Guest

  3. #3

    Default Re: Search Birthday Date in 30 days future without year

    In reply to byJTa.131370$N7.19332@sccrnsc03 on 7/23/03 9:48 PM by Daniel R.
    Sloan [email]danielsloan@comcast.net[/email]:
    > Success, how about Sort - Month / Day without year?
    >
    > Daniel R. Sloan
    >
    >
    Hi Daniel,

    FileMaker has a lot of built in date features.

    Here is another approach that may be of use:

    Field Name Field Type Formula / Entry Option
    Birthday Date
    NextbirthdayMonth Calculation (Number) = Month(Birthday)
    NextbirthdayDay Calculation (Number) = Day(Birthday)
    NextbirthdayMonthWarning Calculation (Number) = Month(Birthday - 30)

    And you can sort by the month and day calculations

    HTH

    Lee

    Lee Smith Guest

  4. #4

    Default Re: Search Birthday Date in 30 days future without year

    [posted and mailed]

    I know this may be a little late but . .

    I found the easiest way is to sort by month and date sans the year is to
    use the following calculated field -

    zc.SortDate(text): If( Month( Date ) < 10 , "0" ,"" ) & Month( Date ) &
    "." & If( Day( Date ) < 10 , "0" ,"" ) & Day( Date )

    you end up with a calculated result like 03.12 for a date of 3/12/2001 and
    it should sort just fine.




    "Daniel R. Sloan" <danielsloan@comcast.net> wrote in news:byJTa.131370
    $N7.19332@sccrnsc03:
    > Success, how about Sort - Month / Day without year?
    >
    > Daniel R. Sloan
    >
    >
    Brent Simon Guest

Similar Threads

  1. Add 5 week days to todays date
    By surfguy in forum Coldfusion - Getting Started
    Replies: 1
    Last Post: April 15th, 07:00 PM
  2. Add days to Date variable
    By TheScarecrow in forum Macromedia ColdFusion
    Replies: 1
    Last Post: March 21st, 07:05 PM
  3. DateDiff days before a specific date
    By Mike Paim in forum Macromedia ColdFusion
    Replies: 2
    Last Post: March 3rd, 10:06 PM
  4. Replies: 0
    Last Post: September 8th, 11:32 PM
  5. Adding days to a date
    By Donpro in forum PHP Development
    Replies: 4
    Last Post: August 13th, 07:17 AM

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