Brian Dunning's FileMaker Custom Functions

ITC_list__TextToDateList ( valueList )

Convert a list of dates in the format YYYY/MM/DD to a list of dates in the format DD/MM/YYYY

  Average rating: 4.3 (28 votes) Log in to vote

SL   SL
ITC

Share on Facebook Share on Twitter

  Sample input:
"2005/01/10¶
2006/07/13¶
2006/01/03¶"
  Sample output:
"10/01/2005¶
13/07/2006¶
03/01/2006¶"

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

This CF needs only a value: a value list!
It receives a list of dates formatted as YYYY/MM/DD and returns a list of dates in the format DD/MM/YYYY
This CF is complementary to "ITC_list__DateToTextList ( valueList )"

Send suggestions and comments to < lexan@mac.com >

 

Comments

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.