<
p>The RSS date/time format is a pain to create if you are building the XML for your RSS feed in a text editor. To make things simple, I created a single line of VBA code that would generate a properly formatted RFC 822 date string that can be used in your RSS feed file.
? format(Now(),"ddd, dd mmm yyyy hh:mm:ss") & " GMT"
http://www.cvisual.com/film-techniques/film-interview-jack-sekowski.asp
1. Open any Microsoft Office application.
? format("12/25/06 11:59:59","ddd, dd mmm yyyy hh:mm:ss") & " GMT"
4. Enter the following code into the window (all on a single line) and press the Enter key:
6. If you want to format a particular date/time, you can use code such as:
http://www.cvisual.com/film-techniques/film-interview-jack-sekowski.asp
Interview with screenwriter Jack Sekowski that also includes free download of a produced script "Who's Your Daddy?"
In the XML file for your RSS Feed, Podcast, or Vodcast, you can add a publication date to an item like this (see line):
Arts/Movies/Filmmaking
3. You should see the Immediate window at the bottom of the screen. If not, select the View > Immediate Window menu option.
5. You should see the properly formatted date and time for the present moment appear on the line below. Simply copy the text and paste it into your RSS feed file!
2. Open the Microsoft Visual Basic development editor (in Word, it is available through the Tools > Macro > Visual Basic Editor menu).
Interview with screenwriter Jack Sekowski
To generate a string for the current date-time, follow these steps:
Thu, 01 Jun 2006 09:27:21 GMT
Previous article: 21 December 2006
|
Home
