Our Preferred 5 Star Hosting Provider - Award Winning FileMaker Pro Hosting
Results 1 to 3 of 3
  1. #1
    Forum Member
    Join Date
    Feb 2017
    Posts
    2
    Location
    Baltimore,MD
    FileMaker Pro Software
    FileMaker 11 Advanced
    OS
    Windows
    Skill Level
    Intermediate
    Last Post
    02-27-2017
    Local Date
    10-18-2017
    Local Time
    09:57 AM
    Last Active
    02-27-2017

    Month name based on week number

    How can I get Filemaker to return the month name based on week number?
    I.E. week # 3 = January, Week Number 6 = February ETC.
    I have multiple records that I have grouped based on week number and I would like to show the month Name that those records fall in based on which week number they are in.
    Thanks

  2. #2
    Good guy doughemi's Avatar
    Join Date
    Apr 2005
    Posts
    1,274
    Location
    Middleport, NY USA
    FileMaker Pro Software
    FMPA 14
    OS
    Windows & Mac
    Skill Level
    Intermediate
    Last Post
    10-16-2017
    Local Date
    10-18-2017
    Local Time
    10:57 AM
    Last Active
    10-18-2017
    You can use Michael Horak's WeekStart custom function (https://www.briandunning.com/cf/1439) in a calculation:
    MonthName(WeekStart(weekOfYear; year)).
    Give the gift of life. Register as an organ donor today!
    http://www.organdonor.gov/becomingdonor

  3. #3
    Forum Member
    Join Date
    Feb 2017
    Posts
    2
    Location
    Baltimore,MD
    FileMaker Pro Software
    FileMaker 11 Advanced
    OS
    Windows
    Skill Level
    Intermediate
    Last Post
    02-27-2017
    Local Date
    10-18-2017
    Local Time
    09:57 AM
    Last Active
    02-27-2017
    Quote Originally Posted by golfdave View Post
    How can I get Filemaker to return the month name based on week number?
    I.E. week # 3 = January, Week Number 6 = February ETC.
    I have multiple records that I have grouped based on week number and I would like to show the month Name that those records fall in based on which week number they are in.
    Thanks
    Thank you Very Much.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Need to find number of week days between two dates
    By dmarques in forum FileMaker Pro 9
    Replies: 10
    Last Post: 09-25-2011, 10:21 AM
  2. Replies: 4
    Last Post: 07-27-2011, 02:53 PM
  3. Week Number
    By ChrisK in forum FileMaker Pro 9
    Replies: 14
    Last Post: 12-24-2008, 09:28 AM
  4. Display week number and date range
    By ChrisK in forum FileMaker Pro 9
    Replies: 5
    Last Post: 09-17-2008, 06:07 AM
  5. week-month sort/search/summary
    By dcypher in forum Find, Sort and Search
    Replies: 1
    Last Post: 01-11-2003, 11:28 AM

Tags for this Thread

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
  •  
Welcome to the Original FileMaker Forum
With designated forums for almost every FileMaker topic...FileMaker Today is a FREE to join community where you can boost your FileMaker expertise, build better apps & solutions and interact with over 42,000+ FileMaker Developers from all over the world. If you're building FileMaker solutions, this is the place for you.
Follow FMT
We Are FMT
FMT is home of The World's leading FileMaker News Site, Worldwide Developer Directory, FileMaker Connect Community and so much more.