ISO8601ParseDate ( isoDate )

Strictly parse a YYYY-MM-DD ISO 8601 Date into a FileMaker Date.

Be the first to rate this function Log in to vote

Sam Barnum - Show more from this author
360Works
http://360works.com

Sample input:

ISO8601ParseDate("1975-06-09")

Sample output:

06/09/1975

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

Let ( 
  [
    yearString  = Left ( isoDate ; 4 ) ;
    dash1       = Middle ( isoDate ; 5 ; 1 ) ;
    monthString = Middle ( isoDate ; 6 ; 2 ) ;
    dash2       = Middle ( isoDate ; 8 ; 1 ) ;
    dayString   = Right ( isoDate ; 2 ) ;
    yearNum     = GetAsNumber ( yearString ) ;
    monthNum    = GetAsNumber ( monthString ) ;
    dayNum      = GetAsNumber ( dayString )
  ] ;
  Case ( 
    IsEmpty ( isoDate ) ;
      "" ;
    ( Filter ( yearString ; "0123456789" ) ≠ yearString or
              Filter ( monthString ; "0123456789" ) ≠ monthString or
              Filter ( dayString ; "0123456789" ) ≠ dayString or
              dash1 ≠ "-" or
              dash2 ≠ "-" or
              monthNum < 1 or 
              monthNum > 12 or 
              dayNum < 1 or 
              dayNum > 31 ) ;
      "?" ;
    Date ( monthNum ; dayNum ; yearNum )
  )
)

Tries to be strict in parsing, to avoid any invalid characters, decimal points, and out-of-range issues with months / days.

Comments

		Beverly Voth, beverlyvoth Feb 27, 2020
Did you know that YYYY+MM+DD is a valid `DATE` field for FileMaker? You can just Substitute( theDate ; "-" ; "+" ) This should work to return m/d/yyyy (or d/m/yyyy for those who use it). Make sure the result is DATE type. IDK FM the version that this became possible, so YMMV (or YKMV).

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

ISO8601ParseDate ( isoDate )

Comments

Support this website.

Support this website.