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 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">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">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>