reformats any date into a US formatted date with a specified delimiter. Gives 2 digits for month/day and a choice of 2 or 4 digits for the year.
Be the first to rate this function Log in to vote
|Eddie Albert - Show more from this author|
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Reformats any date into a US formatted date with a specified delimiter. Gives 2 digits for month/day and a choice of 2 or 4 digits for the year.
Useful for adding dates to exported file names using a period ur underscore to separate the month/day/year
DateDelim("1/1/18";"_";2) = 01_01_18
DateDelim("1/1/18";".";4) = 01.01.2018
DateDelim("1/1/18";"/";2) = 01/01/18
Jan 2, 2019
|It appears that for the month and day to be 2-digit long, the expression should be "<=9" or "<10" and not "<9" as stated in the Let function. Otherwise, September or the 9th of any month would still render as a one-digit month or day.|
Jan 15, 2019
|Thank you De So. You are correct. It has been fixed.|
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.