Convert WEEK and YEAR fields data into a DATE
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