Shopping Cart
FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.
|
||||||||||||||||||||||||||||||||||||||||
FormatDateAsText ( baseDate ; Format ) Rate this function:   Discuss this Custom Function Eilert Sundt, Eilert Sundt Systemdesign Formats a date with a specifiable format
Description:This custom function takes as input a date and a text representation of a date format and returns a formatted date as a text string. Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems. This is my Custom Function and I want to edit it Discuss:Sorry for returning to this so late. I accidentally pasted the wrong code initially. It should work now. Eilert Sundt, Hammerfest, Norway Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post: |
|
|||||||||||||||||||||||||||||||||||||||
I couldnt get that to work as advertised.
Shouldn't it be something like this
// DateAsText ( TheDate ; Format )
// Supports YYYY and YY, MM and M ; DD and D formats
// separators should be set in Format (use a value list)
// not recursive
Let
(
[
TheYear = Right ( Year ( TheDate ) ; PatternCount (Format ; "Y") ) ;
TheMonth = Case ( Month ( thedate ) ≤ 9 ; Right ( "00" & Month ( thedate ) ; PatternCount ( Format ; "M" ) ) ; Month ( thedate ) ) ;
TheDay = Case ( Day ( thedate ) ≤ 9 ; Right ( "00" & Day ( thedate ) ; PatternCount ( Format ; "D" )) ; Day ( thedate ) ) ;
Simplified = Substitute ( Format ; ["YY" ; "Y" ] ; ["YY" ; "Y" ] ; ["MM" ; "M" ] ; ["DD" ; "D" ] )
] ;
Substitute ( Simplified ; [ "Y" ; TheYear ] ; [ "M" ; TheMonth ] ; [ "D" ; TheDay ] )
)
maarten, arnhem
September 30, 2009 3:14pm