That's the same way that I was doing it... I don't believe there is a more efficient way to do it.<br><br>-Adam<br><br> <div class="gmail_quote">On Sat, Jun 6, 2009 at 11:06 AM, Mike O <span dir="ltr"><<a href="mailto:mikeeo@msn.com">mikeeo@msn.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div bgcolor="#ffffff">
<div><font face="Arial" size="2">Adam,</font></div>
<div><font face="Arial" size="2"></font> </div>
<div><font face="Arial" size="2">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 face="Arial" size="2"></font> </div>
<div><font face="Arial" size="2">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 face="Arial" size="2">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: 2px solid rgb(0, 0, 0); padding-left: 5px; padding-right: 0px; margin-left: 5px; margin-right: 0px;"><div class="im">
<div style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;">----- Original Message ----- </div>
<div style="background: rgb(228, 228, 228) none repeat scroll 0% 0%; font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
<b>From:</b>
<a title="adman@adman.net" href="mailto:adman@adman.net" target="_blank">Adam Blomfield</a>
</div>
<div style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"><b>To:</b> <a title="mikeeo@msn.com" href="mailto:mikeeo@msn.com" target="_blank">Mike O</a> </div>
<div style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"><b>Cc:</b> <a title="cisco-voip@puck.nether.net" href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a> </div>
<div style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"><b>Sent:</b> Friday, June 05, 2009 3:08 PM</div>
<div style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"><b>Subject:</b> Re: [cisco-voip] UCCX scripting
string to date format</div>
<div><br></div></div><div><div></div><div class="h5">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" target="_blank">mikeeo@msn.com</a>></span>
wrote:<br>
<blockquote style="border-left: 1px solid rgb(204, 204, 204); 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 face="Arial" size="2">Thanks,</font></div>
<div><font face="Arial" size="2">Mike</font></div></div><br>_______________________________________________<br>cisco-voip
mailing list<br><a href="mailto:cisco-voip@puck.nether.net" target="_blank">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></div></div></blockquote></div>
</blockquote></div><br>