Newest functions Upload a function Leave a tip My account

There are 2,577 functions in this library.

timeStampFormat ( YYYYMMDDHHMMSS )

converts timestamp string to filemaker timestamp

  Average rating: 4.2 (26 votes) Log in to vote

Hudi Moskowitz Filemechanic http://filemechanic.com

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

GetAsTimestamp ( // DATE GetAsDate ( Middle ( YYYYMMDDHHMMSS ; 5 ; 2 ) & "/" & Middle ( YYYYMMDDHHMMSS ; 7 ; 2 ) & "/" & Left ( YYYYMMDDHHMMSS ; 4 ) ) & " " & // TIME GetAsTime ( Middle ( YYYYMMDDHHMMSS ; 9 ; 2 ) & ":" & Middle ( YYYYMMDDHHMMSS ; 11 ; 2 ) & ":" & Left ( YYYYMMDDHHMMSS ; 2 ) ) ) Click to copy

Converts long timestamp ( I'm getting it from hl7 ) to a FM formatted timestamp.

 

Comments

		comment, VR Feb 5, 2016
You should use the Date() and Time() functions for this, instead of GetAsDate () and GetAsTime (). That will make your function work correctly regardless of the local date and time settings.

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 21 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: