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

 

[Aaron [SQL Server MVP]]

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

 

[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