RFC2822TimestampConvert ( RawStamp )

Converts an RFC 2822 timestamp to a filemaker timestamp

Be the first to rate this function Log in to vote

David A Sullivan - Show more from this author
Mandelbrot LLC
http://mandelbrotllc.com

Sample input:

RFC2822TimestampConvert ( "Fri, 26 Mar 2021 18:20:22 +0000" )

Sample output:

3/26/2021 6:20:22 PM

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

GetAsTimestamp ( 
Case ( 
Middle ( RawStamp ; 9 ; 3 ) = "Jan" ; 1 ;
Middle ( RawStamp ; 9 ; 3 ) = "Feb" ; 2 ;
Middle ( RawStamp ; 9 ; 3 ) = "Mar" ; 3 ;
Middle ( RawStamp ; 9 ; 3 ) = "Apr" ; 4 ;
Middle ( RawStamp ; 9 ; 3 ) = "May" ; 5 ;
Middle ( RawStamp ; 9 ; 3 ) = "Jun" ; 6 ;
Middle ( RawStamp ; 9 ; 3 ) = "Jul" ; 7 ;
Middle ( RawStamp ; 9 ; 3 ) = "Aug" ; 8 ;
Middle ( RawStamp ; 9 ; 3 ) = "Sep" ; 9 ;
Middle ( RawStamp ; 9 ; 3 ) = "Oct" ; 10 ;
Middle ( RawStamp ; 9 ; 3 ) = "Nov" ; 11 ;
Middle ( RawStamp ; 9 ; 3 ) = "Dec" ; 12 ;
"" )
& "/" & Middle ( RawStamp ; 6 ; 2 )
& "/" & Middle ( RawStamp ; 13 ; 4 )
& " " & Middle ( RawStamp ; 18 ; 8 )
)

RFC 2822: An Internet Message Format used to uniformly represent date and time, including in HTTP and email headers. RFC 2822 includes the shortened day of week, numerical date, three-letter month abbreviation, year, time, and time zone, displaying as 01 Jun 2016 14:31:46 -0700 .

This function reformats RFC 2822 into a filemaker formatted timestamp.

Comments

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

RFC2822TimestampConvert ( RawStamp )

Comments

Support this website.

Support this website.