Brian Dunning's FileMaker Custom Functions

DotwCWYtoDate ( DOTW ; CW ; Y )


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

Charles Huff   Charles Huff

Share on Facebook Share on Twitter

  Sample input:
  Sample output:

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

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 !



comment   comment, VR
Jul 9, 2016
This will fail in a leap year.
Bernard Moreau   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 Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.