AnsweredAssumed Answered

Migrating from FileMaker Pro5 to FileMaker Pro12

Question asked by EduardoBirbuet on Jan 19, 2013
Latest reply on Jan 22, 2013 by philmodjunk

Summary

Migrating from FileMaker Pro5 to FileMaker Pro12

Product

FileMaker Pro

Version

FileMaker Pro12

Operating system version

OS X Version 10.8.2

Description of the issue

I have a small parish data base on "Filemaker Pro 5" for a long time. Recently I purchase the new version Pro 12 and translated the file "Pro 5" to the newest version,

Steps to reproduce the problem

however, the formula to calculate the birthdays within a week is not responding.

Expected result

Layout"19:   Calculation result: Number
WeekOfYear(BulletinDate)


Layout: BirthdayNamesWeekOfBulletin
Calculation result: text
with the formula:

If(WeekOfYear(Mr. YEAR BIRTH) = WeekOfYear(BulletinDate);
    MR.&"("&GetAsText(Mr. YEAR BIRTH)&")";"") & "  " &
If(WeekOfYear(MRS. YEAR BIRTH) = WeekOfYear(BulletinDate);
    MRS.&"("&GetAsText(MRS. YEAR BIRTH)&")";"") & "  " &
If(WeekOfYear(ON A YEAR BIRTH) = WeekOfYear(BulletinDate);
    ON A&"("&GetAsText(ON A YEAR BIRTH)&")";"") & "  " &
If(WeekOfYear(ON B YEAR BIRTH) = WeekOfYear(BulletinDate);
    ON B&"("&GetAsText(ON B YEAR BIRTH)&")";"") & "  " &
If(WeekOfYear(ON C YEAR BIRTH) = WeekOfYear(BulletinDate);
    ON C&"("&GetAsText(ON C YEAR BIRTH)&")";"") & "  " &
If(WeekOfYear(ON E YEAR BIRTH) = WeekOfYear(BulletinDate);
    ON E&"("&GetAsText(ON E YEAR BIRTH)&")";"") & "  " &
If(WeekOfYear(ON F YERA BIRTH) = WeekOfYear(BulletinDate);
    ON F&"("&GetAsText(ON F YERA BIRTH)&")";"") & "  " &
If(WeekOfYear(ON G YEAR BIRTH) = WeekOfYear(BulletinDate);
    ON G&"("&GetAsText(ON G YEAR BIRTH)&")";"") & "  " &
If(WeekOfYear(ON H YEAR BIRTH) = WeekOfYear(BulletinDate);
    ON H&"("&GetAsText(ON H YEAR BIRTH)&")";"") & "  " &
If(WeekOfYear(ADULT YEAR BIRTH) = WeekOfYear(BulletinDate);
    ADULT&"("&GetAsText(ADULT YEAR BIRTH)&")";"") & "  " &
If(WeekOfYear(ADULT 2 YEAR BIRTH) = WeekOfYear(BulletinDate);
    ADULT 2&"("&GetAsText(ADULT 2 YEAR BIRTH)&")";"") & "  "
 

Actual result

This formula works fine with FileMaker Pro 5

Exact text of any error message(s) that appear

With this formula I am able to find the birthdays within week of any giving date.

photo-Filemaker.JPG

Outcomes