CF.DotwCwYearToDate ( DOTW ; CW ; Y )

Converts "Day of the week" and "Calendar week" and "Year" to a date.

Average rating: 4.2 (19 votes) Log in to vote

Thomas Hellwig
Delasocial GmbH
http://www.delasocial.com

Sample input:

CF.DotwCwYearToDate ( 1 ; 1 ; 2016 )
CF.DotwCwYearToDate ( 7 ; 8 ; 2016 )
CF.DotwCwYearToDate ( 1 ; 0 ; 2016 )
CF.DotwCwYearToDate ( -1 ; -1 ; 2016 )

Sample output:

04.01.2016
28.02.2016
28.12.2015
19.12.2015

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

/*############################################################################################
 
___ Function name: CF.DotwCwYearToDate ( DOTW ; CW ; Y )
___ Version: 1.0 --- April 26th 2016
___ Code language: German
___ FMP version: 12
___ Written on April 26th 2016
___ Author: Thomas Hellwig
___ Contact: grafzahl68@gmx.de

Description:
Converts "Day of the week" and "Calendar week" and "Year" to a date (german DIN 1355-1).
 
Version notes:
1.0: This CF works only with the date format used in germany, switzerland, austria and many other countries in europe, middle and south america, middle east, russia, australia, north afrika and some more states (Day.Month.Year). Monday is the first day of the week, sunday is the 7th day of the week.
Please note that the code was written in FileMaker version 12.

Parameters:
(DOTW) Possible values:
Day number of the week ... 1 to 7
 
(CW) Possible values:
Calendar week number of the year ... 1 to 53
 
(Y) Possible values:
Number of the year ... e.g. 2016

Input/Output:
1 ; 1 ; 2016 ... 04.01.2016
7 ; 8 ; 2016 ... 28.02.2016
1 ; 0 ; 2016 ... 28.12.2015
-1 ; -1 ; 2016 ... 19.12.2015
 
############################################################################################*/

SetzeVars ( 
[ 
F = LiesAlsDatum ( "01.01." & Y ) ; 
L = LiesAlsDatum ( "31.12." & Y ) ; 
TDJ = TagDesJahres ( L ) ; 
W = ( ( WocheImFiskaljahr ( L ; 1 ) - CW + 1 ) * 7 ) - DOTW 
] ; 

F + ( TDJ - W )

)  //___End

//############################################################################################

Converts "Day of the week" and "Calendar week" and "Year" to a date (german DIN 1355-1).

This CF works only with the date format used in germany, switzerland, austria and many other countries in europe, middle and south america, middle east, russia, australia, north afrika and some more states (Day.Month.Year). Monday is the first day of the week, sunday is the 7th day of the week.

Please note that the code was written in FileMaker version 12.

Comments

		comment, VR Jul 12, 2016
This will fail in a leap year.

		comment, VR Jul 12, 2016
See the comments here: http://www.briandunning.com/cf/229 for a correct calculation that is much simpler and will work with any date format in use.

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

CF.DotwCwYearToDate ( DOTW ; CW ; Y )

Comments

Support this website.

Support this website.