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.

Support this website.

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

Under construction. Email me your wish list for improvements.