Newest functions Upload a function Leave a tip My account

There are 2,520 functions in this library.

Timestamp_Format_RFC822 ( _timestamp ; _timezone )

Formats valid RFC2822-timestamps as FMP-timestamps or vice versa.

  Average rating: 4.6 (34 votes) Log in to vote

Rewolfer - Show more from this author http://rewolfer.de

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

/*========================================= FORM: Timestamp_Format_RFC822 ( _timestamp ; _timezone ) PURPOSE: formats valid RFC2822-timestamps as FMP-timestamps or vice versa PARAMETER: _timestamp RFC822 or FMP-timestamp regional _timezone number -11.5 to 11.5 RESULT: FMP-timestamp or RFC822-timestamp or nothing DEPENDENCY: IsTimestamp() NOTE: valid FMP-timestamp will be formatted as RFC822-timestamp with timezone (if supplied as decimal hour) valid RFC822-timestamp will be formatted as FMP-timestamp (as UniversalTime if _timezone is not 0 or not empty) no in-/ output of textual timezones like "EST" tolerates whitespace tolerates 2-digit-years in RFC822-timestamps requires 4-digit-years in FMP-timestamps see IsTimestamp(), IsDate(), IsTime() for further details EXAMPLE: Stamp_Format_RFC822 ("09/12/2002 18:12:17"; -3.5 ) => "Thu, 12 Sep 2002 18:12:17 -0330" (Newfoundland Standard Time) Stamp_Format_RFC822 ("Thu, 12 Sep 2002 18:12:17 +0200"; "" ) => "09/12/2002 18:12:17" Stamp_Format_RFC822 ("Thu, 12 Sep 2002 18:12:17 +0200"; 1 ) => "09/12/2002 16:12:17" (Universal Time/ GMT) Stamp_Format_RFC822 ("Tue, 30 Feb 2002 18:12:17 +0630"; 1 ) => "" (invalid date) HISTORY: 2006-03-01 [145342] 1.00 sw initial version 2006-03-01 [210707] 2.00 sw with local time and error checking 2007-02-19 [003455] 2.10 sw needed update because of changes to Text_Get_DelimitedValue-function 2011-03-15 [192012] 2.20 sw renamed according to new naming convention 2011-03-16 [115008] 3.00 sw if other than ISO-dates were used, function didn't work 2011-09-15 [145831] 3.01 sw new documentation 2012-04-23 [223756] 4.00 sw merged functions; converts timestamp to RFC822 or vice versa 2012-04-25 [214219] 4.10 sw shorten code thru IsTimestamp() DEVELOPER: tsw @ http://rewolfer.de =========================================*/ Click to copy

This function was merged with its counterpart into:
Timestamp_Format_RFC822 ()

You can find it here:
http://www.briandunning.com/cf/1235

 

Comments

		Steve Savery, United Kingdom Mar 15, 2011
Inputting "Thu, 20 Jan 2011 14:37:15 +0000" with timezoned either true or false returns '?'. I'm using FileMaker 11, would this explain the problem or do you know what else might be the cause?

		TS Wolf, Berlin Mar 15, 2011
hello steve, if i use your value my filemaker 11.02 shows as it should "2011-01-20 14:37:15". the timezoned-parameter only kicks in if set to 1; all other values will be ignored. did you check: • installation of the other custom function (get_explodedkey) • using the right format in your calculation (timestamp)? i hope i could be of any help, ts wolf.

		Steve Savery, United Kingdom Mar 15, 2011
Thanks for the reply. I'm use FMA 11 v2 with both custom functions installed correctly (to the best of my knowledge, I've also just placed them into a new db to check) and am calling it thus convert_date_rfc822timestamp ( "Thu, 20 Jan 2011 14:37:15 +0000" ; "0" ) but am still returned "?". You ask if I'm using the correct timestamp format; I'm using the Data Viewer to test this custom function as shown above.

		TS Wolf, Berlin Mar 15, 2011
hello steve, i re-checkt the code here at brian dunning and it seems that some chars were not saved correctly (is same or greater). so i used ">=" now. can you try this updated version, please, since the custom function works as expected in my installation (http://i53.tinypic.com/e968at.png).

		Steve Savery, United Kingdom Mar 15, 2011
Sorry to report that I am still getting the same result. I've compared the function above with what I had previously and can see the ">=" differences, so I'm sure I have the correct new code to test with. (see http://tinypic.com?ref=21az9kg)

		TS Wolf, Berlin Mar 15, 2011
i reposted the entire code. since i had renamed the function you have to rename GET_EXPLODEDKEY to STRING_GET_EXPLODE. if nothing helps you can download a demo-file under http://tinyurl.com/67m48wt tell me if you found something, please.

		Steve Savery, United Kingdom Mar 16, 2011
I fear I may have been wasting your time. Your example file works first time, yet if I delete the earlier custom functions from my db and import yours from the supplied file it fails in my db. Yet it still works in your example db. Could it be a limitation of hosted files? Or a conflict with other custom functions?

		TS Wolf, Berlin Mar 16, 2011
i think i found it: i created a file with british time settings and got the same result as you. i fixed the handling of international dates and hope the function now works in your db as well. copy new code and post if it works. thanks for your extensiv feedback.

		Steve Savery, United Kingdom Mar 16, 2011
Hi, yes found the same thing. So I've changed around date_year with date_day when formatting the date from the string. Many, many thanks for all your help. This is about to put to very good use!

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