Newest functions Upload a function Leave a tip My account

There are 2,572 functions in this library.

DayWeekYear2Date ( dayNR ; weekNR ; yearNR )

Turns DayNr. WeekNr. & Year into a Date

  Average rating: 3.9 (49 votes) Log in to vote

Arjen van der Ree Maxperts http://www.maxperts.nl

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Let ( [ // determine the typical week-offset in [week 5] of the year [yearNR] . . . $checkdate = GetAsDate (Date (1 ; 1 ; yearNR) + (7 * 5 ) ) ; $checkweek = WeekOfYearFiscal ($checkdate ; 2) ; $wkoffset = 5 - $checkweek ; //make sure that we stay away from week 52/53 in correctional-data; we keep the remaining 21 days in a var $saveweekNR = Case (weekNR > 50 ; weekNR - 3 ; weekNR ) ; $reservedays = Case ( weekNR > 50 ; 21 ; 0 ) ; //first leap to the aproximate date as a basic startpoint, find the right offset for the day-nr. $leapdate = GetAsDate (Date ( 1 ; 1; yearNR) + (7 * ($saveweekNR-$wkoffset) ) ) ; $dayoffset = DayOfWeek ($leapdate) - dayNR ; //maandag = 2 ... vrijdag = 6 //First try (FT) to get close to a plausible date on the right day-nr.: $FTdate = GetAsDate ($leapdate-$dayoffset) ; $FTweek = WeekOfYearFiscal ($FTdate ; 2) ; // Second Correction (SC) with a plausible date, offset is in days (weekoffset x 7) $SCoffset = ($saveweekNR - $FTweek) * 7 ] ; GetAsDate ($FTdate + $SCoffset + $reservedays) // $reservedays :: if we put 2 week aside to stay away from week 52/53 we need to put them back here ! ) Click to copy

In many overviews (calendars e.g.) users want to use week numbers & years to see a set of days (mon - fri). This function makes is easy to translate from week-numbers, years and day-numbers (2=monday ... 6 = friday) to calculate say 5 dates to relate to records/portals in a week view.
I couldn't find anything like this on the internet and it took quite some time and testing to get is to work properly.
[dayNR ; 2 .. 5 (mon - fri) ]
[weekNR ; 1 ... 53*
[yearNR ; any year that Filemaker supports ]

*week-number 53 will goto wk 1 the following year in most cases.

 

Comments

		comment, VR Dec 25, 2011
Couldn't this be simpler? See: http://www.briandunning.com/cf/229

		Peter Bouma, Amsterdam Mar 18, 2016
I'm not happy with the declaration of script variables ($...) in this function. They should remain local/private within the Let statement of this CF. One way to mark them as private is to use '~' or '@' (in fact anything different from '$' or '$$') instead of the '$' prefix used here.

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 21 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: