DateRSSPubDate ( theDate )

Formats the Date as 'Fri, 29 Aug 2008'.

Average rating: 4.5 (30 votes) Log in to vote

Hal Gumbert - Show more from this author
CampSoftware
http://www.campsoftware.com

Sample input:

DateRSSPubDate ( Get ( CurrentDate ) )

Sample output:

Fri, 29 Aug 2008

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

// DateRSSPubDate ( theDate )
// Formats the Date as 'Fri, 29 Aug 2008'

Let ( [

theDayOfWeek = Case ( 
DayOfWeek ( theDate ) = 1 ; "Sun" ; 
DayOfWeek ( theDate ) = 2 ; "Mon" ; 
DayOfWeek ( theDate ) = 3 ; "Tue" ; 
DayOfWeek ( theDate ) = 4 ; "Wed" ; 
DayOfWeek ( theDate ) = 5 ; "Thu" ; 
DayOfWeek ( theDate ) = 6 ; "Fri" ; 
DayOfWeek ( theDate ) = 7 ; "Sat" ; 
""
) ; 

theMonthName = Case ( 
Month ( theDate ) = 1 ; "Jan" ; 
Month ( theDate ) = 2 ; "Feb" ; 
Month ( theDate ) = 3 ; "Mar" ; 
Month ( theDate ) = 4 ; "Apr" ; 
Month ( theDate ) = 5 ; "May" ; 
Month ( theDate ) = 6 ; "Jun" ; 
Month ( theDate ) = 7 ; "Jul" ; 
Month ( theDate ) = 8 ; "Aug" ; 
Month ( theDate ) = 9 ; "Sep" ; 
Month ( theDate ) = 10 ; "Oct" ; 
Month ( theDate ) = 11 ; "Nov" ; 
Month ( theDate ) = 12 ; "Dec" ;
""
) 

] ; 

theDayOfWeek & ", " & Day ( theDate )  & " " & theMonthName & " " & Year ( theDate )

)

Formats the Date as 'Fri, 29 Aug 2008'. We needed this to create an RSS Feed which requires a special date format.

Comments

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

DateRSSPubDate ( theDate )

Comments

Support this website.

Support this website.