Brian Dunning's FileMaker Custom Functions

DotwCWYtoDate ( DOTW ; CW ; Y )

Converts

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

Charles Huff   Charles Huff
Huffco
http://lakerussellshop.com

Share on Facebook Share on Twitter

  Sample input:
Dotwcwytocate(1;28;2016)
  Sample output:
7/3/2016

  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 !

 

Comments

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 BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.