DateFormat_DDMMYYYY ( MyDate )

Converts a date into UK format DD/MM/YYYY

Be the first to rate this function Log in to vote

Patrick Mathers - Show more from this author
Records Doctor
https://recordsdoctor.com

Sample input:

DateFormat_DDMMYYYY ( "04/07/2024" )

Sample output:

"07/04/2024"

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

Let (
    [
        dateValue = GetAsDate( MyDate );
        day = Day ( dateValue );
        month = Month ( dateValue );
        year = Year ( dateValue )
    ];
    Right ( "00" & day ; 2 ) & "/" & Right ( "00" & month ; 2 ) & "/" & year
)

A simple custom function that converts any date value into UK format of DD/MM/YYYY.

Comments

		Robert D Trammel Jul 29, 2024
You should wrap MyDate in a GetAsDate function. That way you can at least trap for scenarios where there is an invalid date as an input. Let([ dateValue = GetAsDate( MyDate ); ... ]; ... )

		Patrick Mathers, Records Doctor Jul 30, 2024
Thanks Robert. I have adjusted it with your suggestion.

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

DateFormat_DDMMYYYY ( MyDate )

Comments

Support this website.

Support this website.