Date calc error

[JTSmith]

I'm struggling...  does anyone have a quick/easy way to format the below as a standard date?  

Input: 2018-11-14T11:31:26.113

I would like it to format to: 11/14/2018 so I can use filemaker to sort by date, etc.  

Any help would be greatly appreciated!

[comment]

If you want to use the given input as a date (or as a timestamp) then this is not a question about formatting. You need to take the text input, convert it to date and store it in another field - either a calculation field returning a date result, or a date field.

The result will then be displayed in the date format used by your file - or in another format you chose for the field in Layout mode.

The conversion itself is rather trivial:

Let ( [
y = Left ( Input ; 4 ) ;
m = Middle ( Input ; 6 ; 2 ) ; 
d = Middle ( Input ; 9 ; 2 ) 
] ; 
Date ( m ; d ; y )
)

 

 

[JTSmith]

Thank you sir!