RFC 2822 Date format not supported?

[XmisterIS]

I tried passing a value in RFC 2822 format to the DateTime and CDate functions respectively and on each occasion I get a "type mismatch" error. I subsequently re-formatted each of the values in "YYYY/MM/DD HH:MM:SS" format (which is an ugly hack) and they were succesfully cast to Date data types.

Now ... am I missing something really obvious here, or does Excel VBA really not support RFC 2822 Date format, which has been around in one form or another since 1980-something and is used by damn near everything on the internet???!!

I don't believe that, there must be a built-in that can cast an RFC 2822 date string to a Date data type.

[FDibbins]

I have no idea what an RFC 2822 date format is, but a quick google search did not turn up much (meaning that it is probably not suppoprted). However, this link may be of use?

http://www.java2s.com/Code/Android/D...dUTCformat.htm

[XmisterIS]

Yep, that's pretty much what I've done in VBA. I guess there is no built-in for it.

for information, RFC2822 is defined here: http://tools.ietf.org/html/rfc2822 AFAIK, it used to be used exclusively for email communication, but now it is used by a lot more than that.

[FDibbins]

Thanks for the link, sorry I could not help more

[XmisterIS]

No probs

[shg]

Formula?

	A	B	C
1	Fri, 09 Sep 2005 13:51:39 -0700	09 Sep 2005 20:51:39	B1: =MID(A1, 6, 20) - DOLLARDE(RIGHT(A1, 5)/100, 60) / 24