Brian Dunning's FileMaker Custom Functions

DotwCWYtoDate ( DOTW ; CW ; Y )


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

Charles Huff   Charles Huff - Show more from this author

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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 16 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: