Parsing dates in a variety of formats?

Hi,

I'm trying to parse dates that come in a variety of formats from RSS feeds.

strToTime() will parse

29-04-2005 22:52 successfully,

but not

2005-04-30T09:19:49 +00:00

I have no control over the input formats, and am trying to find a single
function that will parse the date regardless of it's format.

Could anyone help me with this?

Thanks,

Lazaroo.


.

Relevant Pages

  • Re: Options when it comes to searching dates?
    ... declare @date int ... declare @time int ... You must parse and then be ... > Can I assume that you are referring to free-form date formats, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Parsing Serial Numbers?
    ... As I uderstood, there is 2 formats, both of fixed length. ... I'd like to be able to parse these into 3 groups. ... > character format. ... > parse function in XL and was very surprised that there isn't one. ...
    (microsoft.public.excel)
  • Text parsing application needed
    ... analyze and parse text files in various formats (delimited, fixed length, ... Excel) into Access or SQL database. ...
    (microsoft.public.vsnet.general)
  • Re: Various strings to dates.
    ... I moved the dateutil directory over to ... ImportError: cannot import name parse ... > string. ... > formats I will encounter here. ...
    (comp.lang.python)
  • Re: Question about using RTF2 control with merge
    ... formatting control codes. ... An object, such as an RTF ActiveX control, ... > "Stephen Lebans" ... >> Programmatically parse the RTF encoded string data directly which is ...
    (microsoft.public.access.forms)