Converting 25062002120236 to a date!

[Quintus Snapper]

How can I convert a string such as 25062002120236 into a date
(25-06-2002 12:02:36). I have tried using the CDate() & ISDate()
functions but they don't recognise and convert this into a date.

Thanks in advance,

Quintus

[Andrew Urquhart]

*Quintus Snapper* wrote:

How can I convert a string such as 25062002120236 into a date
(25-06-2002 12:02:36). I have tried using the CDate() & ISDate()
functions but they don't recognise and convert this into a date.

In JScript: (watch out for line-wrapping)
var intDate = 25062002120236;
var strDate =
intDate.toString().replace(/(\d{2})(\d{2})(\d{4})(\d{2})(\d{2})(\d{2})/,
"$1-$2-$3 $4:$5:$6");
Response.Write(strDate);
--
Andrew Urquhart
- FAQ: www.aspfaq.com
- Archive: www.tinyurl.com/38kzx
- Contact me: http://andrewu.co.uk/contact/
- This post is probably time-stamped +1 hour - blame my ISP (NTL)

[Aaron [SQL Server MVP]]

<%
fkdt = "25062002123506"
response.write cdate(mid(fkdt, 5,4) & "-" & mid(fkdt, 3,2) & "-" &
left(fkdt,2))
%>

--
http://www.aspfaq.com/
(Reverse address to reply.)


"Quintus Snapper" <qs******@gmail.com> wrote in message
news:34**************************@posting.google.c om...

How can I convert a string such as 25062002120236 into a date
(25-06-2002 12:02:36). I have tried using the CDate() & ISDate()
functions but they don't recognise and convert this into a date.

Thanks in advance,

Quintus

[Quintus Snapper]

Thanks! works like a charm, easy when you know how!

Should someone also have a similar issue and also wants the time, it
would look like:

fkdt = "25062002123506
cdate(mid(fkdt, 5,4) & "-" & mid(fkdt, 3,2) & "-" & left(fkdt,2) & " "
& mid(fkdt, 9,2) & ":" & mid(fkdt, 11,2) & ":" & mid(fkdt, 13,2))

Q
"Aaron [SQL Server MVP]" <te*****@dnartreb.noraa> wrote in message news:<OP*************@tk2msftngp13.phx.gbl>...

<%
fkdt = "25062002123506"
response.write cdate(mid(fkdt, 5,4) & "-" & mid(fkdt, 3,2) & "-" &
left(fkdt,2))
%>

--
http://www.aspfaq.com/
(Reverse address to reply.)


"Quintus Snapper" <qs******@gmail.com> wrote in message
news:34**************************@posting.google.c om...

How can I convert a string such as 25062002120236 into a date
(25-06-2002 12:02:36). I have tried using the CDate() & ISDate()
functions but they don't recognise and convert this into a date.

Thanks in advance,

Quintus