Date formatting to iCal Standard.

Hi
My DB has 2 fields, one which has the date the other has the time.

The date field is called Appt_Date and has values like 12/03/2008 (DD/
MM/YYYY)

The time field is called Appt_Time and has values like 10:30 (am)

I can retrieve both of these fields from the DB and present them on
screen, but I need to do it in iCAL format.

For example, the following represents Janurary 18, 1998, at 11 PM:

19980118T230000

Any idea how I can do this ?

Thanks

re: Date formatting to iCal Standard.

"Jerry Yang" wrote:
No, it doesn't. That might be how they show up when you display them, but I
guarantee you that whatever DB you are using, they are stored in some
unreadable-by-humans internal form. (Well...maybe excepting for MySQL.
Where they will be stored as YYYYMMDD.)
Ditto.
Easy, peasy:

<%
....
dt = RS("Appt_Date")
tm = RS("Appt_Time")
iCalTime = (Year(dt) * 10000 + Month(dt) * 100 + Day(dt) ) _
& "T"
& (Hour(tm)*10000 + Minute(tm) * 100 + Second(tm))
....
%>

Okay?

re: Date formatting to iCal Standard.

"Old Pedant" wrote:Oops...missed the underline on the "T" line.
It should read:
& "T" _

Or you can jam all of that stuff onto a single line of code and get rid of
the underlines. I formatted it like that so it would show cleanly in most
newsreaders. And then blew it. <sigh/>

re: Date formatting to iCal Standard.

Thanks :) very much appreciated..