TimeStampAsRFC822 ( theTS ; Zone )

Converts a timestamp to RFC 822 format

Average rating: 4.4 (31 votes) Log in to vote

Peter Vinogradov - Show more from this author

Sample input:

TimeStampAsRFC822 ( Item::PubDate ; "GMT" )

Sample output:

Sun, 04 Dec 2005 13:05:36 GMT (where Item::PubDate is a field containing the timestamp "12/4/2005 1:05:36 PM" )

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

// Converts a FileMaker timestamp to RFC822, in the format: Sat, 07 Sep 2002 09:42:31 GMT - useful for generating rss xml for podcasts, etc.

Let ( 
[ digitDay = Right (GetAsText (100+ Day (theTS)) ; 2) ;
digitHour = Right (GetAsText (100+ Hour (theTS)) ; 2);
digitMinute = Right (GetAsText (100+ Minute (theTS)) ; 2);
digitSeconds = Right (GetAsText (100+ Seconds (theTS)) ; 2);
a=1 ];

Left ( DayName ( theTS ) ; 3 ) & ", " & digitDay & " " & Left ( MonthName ( theTS );3) & " " & Year (theTS) & " " & digithour & ":" & digitMinute & ":" & digitSeconds & " " & Zone
)

Converts a FileMaker timestamp to RFC822, in the format: Sat, 07 Sep 2002 09:42:31 GMT

I use this as part of a solution to spin the RSS files for podcasts. For my time zone, I would use "-0500" for the "Zone" parameter. Note: my understanding of the RFC822 time spec is pretty poor, but so far this seems to generate valid timestamps for me.

Comments

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

TimeStampAsRFC822 ( theTS ; Zone )

Comments

Support this website.

Support this website.