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 - Show more from this author
ITC

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)

Let ( [ n = ValueCount ( valueList ) ; lv = RightValues ( valueList ; 1 ) ; tv = Left ( lv ; 10 ) ; rd = Right ( tv ; 2 ) & "/" & Middle ( tv ; 6 ; 2 ) & "/" & Left ( tv ; 4 ) & "¶" ; rv = LeftValues ( valueList ; n - 1 ) ] ; Case ( n = 1 ; "" ; ITC_list__TextToDateList ( rv ) ) & rd )

// n  : number of values
// lv : last values
// tv : truncated value (removes trailing ¶)
// rd : reformatted date
// rv : list of remaining values

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

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

ITC_list__TextToDateList ( valueList )

Comments

Support this website.

Support this website.