RFC822 to date format using asp

Question

I try converting RFC822 date format (from rss) into a standard date/time format using asp3.

Thanks

*What* have you tried? What errors are you getting? Samples & logs, please. — DaveE, Dec 13 '10 at 22:33
I tried cDate(temp) or year(temp)&"/"&month(temp)&"/"&day(temp) — user186585, Dec 13 '10 at 22:36

score 1 · Answer 1 · answered Apr 13 '11 at 10:37

Nice solution - the minutes don't always go into double figures though - you'll need to pad those out if minutes are just one digit (I think CDate removes that zero)

eg.

dim theminutes

...

tempDate  = cdate(tempDate) 

if Len(Minute(toReturn))=1 then
    theminutes = "0" & Minute(toReturn) 
else                            
    theminutes = Minute(toReturn) 
end if
RFC822_to_date  = day(tempDate )&"-"&month(tempDate )&"-"&year(tempDate )&" "&hour(tempDate )&":"&theminutes&":00"

score 0 · Answer 2 · answered Dec 14 '10 at 00:46

0

Take a look at the source code of this Classic ASP RSS reader.

There are some funky functions involving the use of JScript, which look like they will work for you.

It looks like you need the VBScript functions parseDate and newDate, and the two JScript functions.

answered Dec 14 '10 at 00:46

thirtydot

224,678
48
389
349

this using CDATE - but for some reason i can't do cdate on my string private function formatDate(aDate) d = cDate(aDate) formatDate = toUTC(year(d), month(d) - 1, day(d), hour(d), minute(d), second(d)) end function – user186585 Dec 14 '10 at 07:59

score 0 · Answer 3 · answered Dec 14 '10 at 08:21

function RFC822_to_date (orginalDate )
 tempDate = trim(right(orginalDate ,(len(orginalDate )-instr(orginalDate,","))))
 tempDate  = left(tempDate ,(len(tempDate)-5))
 tempDate  = cdate(tempDate )
 RFC822_to_date  = day(tempDate )&"-"&month(tempDate )&"-"&year(tempDate )&" "&hour(tempDate )&":"&minute(tempDate )&":00"
end function

RFC822 to date format using asp

3 Answers3