Newest functions Upload a function Leave a tip My account

There are 2,572 functions in this library.

DotwCWYtoDate ( DOTW ; CW ; Y )

Converts

  Average rating: 4.4 (16 votes) Log in to vote

Charles Huff - Show more from this author LakeRussellShop http://LakeRussellshop.com

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

/*############################################################################################ Translated to English by Charles Huff and adjusted for SUNDAY start and SATURDAY end. ___ 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. Version notes: 1.0: This CF works with the date format used in USA. Sunday is the first day of the week, Saturday is the 7th day of the week. Please note that the code was written in FileMaker version 15. 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 ; 28; 2016 ... 07/03/2016 ############################################################################################*/ Let ( [ F = GetAsDate ( "01/01/" & Y ) ; L = GetAsDate ( "12/31/" & Y ) ; DOY = DayOfYear ( L ) ; W = ( ( WeekOfYearFiscal ( L ; 1 ) - CW+2) * 7 ) - DOTW ] ; F + ( DOY - W )-1 ) //############################################################################################ Click to copy

See 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
full credit to Thomas Hellwig... I needed it to work Sunday to Saturday in English... Thank you Thomas !

 

Comments

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

		Bernard Moreau, Borchtlombeek, Belgium Jul 12, 2016
Error in your Sample Input. CW needs to be 28 : Dotwcwytocate( 1; 28;2016) -> 7/3/2016

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: