AnsweredAssumed Answered

Convert WEEK and YEAR fields data into a DATE

Question asked by NilsMortenAlexandersen on Oct 8, 2012
Latest reply on Oct 9, 2012 by Sorbsbuster

Title

Convert WEEK and YEAR fields data into a DATE

Post

     Hello

     I have a DB with separate field for WEEK NR. and YEAR. This is a DB for "work shifts", and where the WEEK NR and YEAR fields contains just a number (i.e.week 12, year 2012)

     I am looking for a method to convert these two numbers into a proper date, that can be included in serches and be sorted.
     The date should be Monday of  that week (if possible, but not absolutely critical)

     Hope someone can help me :-)

     Nils.. curently on FMP 10

Outcomes