> Hi guys,
>
> I have 3 lines of code which I really don't know what they do (I only
> have them because they interface with a mobile provider, they translate
> the XML to CF):
>
> x.DateReceived = REReplaceNoCase(x.xml,
> "^.*<Date>(.*?)</Date>.*$","\1");if(x.DateReceived eq
> xml_in){x.DateReceived = "";};
> x.DateReceived = DateFormat(x.DateReceived, "yyyy-mm-dd");
> x.DateReceived = x.DateReceived & REReplaceNoCase(x.xml,
> "^.*<Time>(.*?)</Time>.*$","\1");if(x.DateReceived eq
> xml_in){x.Datereceived = "";};
>
> But I do know that when I insert x.DateReceived into my database it
> comes out as 2004-03-0911:24:15 which confuses my database. Obviously
> there should be some sort of separator between the date and the time but
> I don't know how to fix those lines of code.
Well ISO date standard (at least for the xml stuff I have worked on) has
a 'T' between the date and time
Try:
x.DateReceived = x.DateReceived & "T" &
REReplaceNoCase(x.xml,"^.*<Time>(.*?)</Time>.*$","\1");
you can try a space too
--
Rob <[EMAIL PROTECTED]>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
