<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18702">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2 face=Arial>Adam,</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>This is what I've come up with, its very slow, but
works. Is there away to do this in the expression editor?</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Set year = s_date.substring(2,4)<BR>Set month =
s_date.substring(4,6 )<BR>Set day = s_date.substring(6)<BR>Set date =
month+"/"+day+"/"+year</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2 face=Arial>s_date String "20090619"<BR>year String ""<BR>day
String ""<BR>month String ""<BR>date Date D[June 5, 2009 10:26:42
PM]<BR></FONT></DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="FONT: 10pt arial; BACKGROUND: #e4e4e4; font-color: black"><B>From:</B>
<A title=adman@adman.net href="mailto:adman@adman.net">Adam Blomfield</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=mikeeo@msn.com
href="mailto:mikeeo@msn.com">Mike O</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A title=cisco-voip@puck.nether.net
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, June 05, 2009 3:08 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [cisco-voip] UCCX scripting
string to date format</DIV>
<DIV><BR></DIV>You have to use the string.substring function to break that
field out into it's seperate components and then piece them back together
again with the slashes into another string, which you can then turn into a
date variable. I had to do something similar recently and it works just fine.
Let me know if you would like a sample aef.<BR><BR>-Adam<BR><BR>
<DIV class=gmail_quote>On Fri, Jun 5, 2009 at 1:33 PM, Mike O <SPAN
dir=ltr><<A href="mailto:mikeeo@msn.com">mikeeo@msn.com</A>></SPAN>
wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0pt 0pt 0pt 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>
<DIV bgcolor="#ffffff">
<DIV><FONT face=Arial>I'm pulling a date from SQL in the following format
"YYYYMMDD" (20090619) how can I read this back to the caller? I tried using
the set command to change it to DATE type and the script bombs.
</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Thanks,</FONT></DIV>
<DIV><FONT size=2
face=Arial>Mike</FONT></DIV></DIV><BR>_______________________________________________<BR>cisco-voip
mailing list<BR><A
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A><BR><A
href="https://puck.nether.net/mailman/listinfo/cisco-voip"
target=_blank>https://puck.nether.net/mailman/listinfo/cisco-voip</A><BR><BR></BLOCKQUOTE></DIV><BR></BLOCKQUOTE></BODY></HTML>