Brian Dunning's FileMaker Custom Functions

@GetAsDate ( text )

Multilingual wrapper for the native GetAsDate() function to handle month names, abbreviations, and ISO-style dates.

  Be the first to rate this function Log in to vote

Alex Zueiv   Alex Zueiv - Show more from this author
Tashkent

Share on Facebook Share on Twitter

  Sample input:
UniqueValues ( List (
@GetAsDate ( "March 31, 2022" ) ; // US required
@GetAsDate ( "2022mar31" ) ;
@GetAsDate ( "31 maart 2022" ) ; // Nederlands required
@GetAsDate ( "31 mrt 22" ) ;
@GetAsDate ( "2022-3-31" ) ; // no specific locale required
@GetAsDate ( "2022年3月31日" ) ;
@GetAsDate ( "2022년 3월 31일" ) ;
) )
  Sample output:
31-03-2022 // if the file locale is Netherlands and the system locale is US

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

Multilingual wrapper for the native GetAsDate() function.

Converts text containing a month name or abbreviation to a date using the file and system locale definitions. If the month is specified as a number, uses the active locale (Use System Formats menu selection) to distinguish it from the day.

Supports the ISO date format and text formats used in China, Japan, and Korea.

Requires FM 19.1.2 or higher.

 

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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 18 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: