rssDateCode ( rssDate ; rssTime )

Format Date Code as used in RSS Feeds

Average rating: 4.3 (32 votes) Log in to vote

Roger Biel
2Geckos Consulting, LLC
www.2geckos.com

Sample input:

rssDateCode( "" ; "" )
rssDateCode( "1/1/2008" ; "10:00 pm" )

Sample output:

Thu, 26 Jun 2008 22:17:00 GMT
Tue, 01 Jan 2008 22:00:00 GMT

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

// rssDateCode( rssDate ; rssTime )

Let( [ rssDate = If( IsEmpty(  rssDate ) ;Get( CurrentTimeStamp ) ; rssDate ) ;
          rssTime = If( IsEmpty(  rssTime ) ;Get( CurrentTimeStamp ) ; rssTime ) ] ;

Left ( DayName ( rssDate ) ; 3 ) & ", " & 
If ( Day ( rssDate  )  < 10 ; "0" ; "" ) & Day ( rssDate  )  
& " " & Left ( MonthName ( rssDate )  ; 3 ) & " " & Year ( rssDate ) & " " & 
If (Hour ( rssTime ) < 10 ; 0 & Hour ( rssTime  ) ; Hour ( rssTime )) & ":" &
If ( Minute ( rssTime  ) < 10 ; 0 & Minute ( rssTime  ) ; Minute ( rssTime  )) & ":00 GMT"

)

Format Date Code as used in RSS Feeds
Tue, 10 Jun 2003 04:00:00 GMT

Comments

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

rssDateCode ( rssDate ; rssTime )

Comments

Support this website.

Support this website.