<div>
Hello badgermike,<br />
<br />
I presume:<br />
<br />
dateserial(left(&quot;20100106&quot;<wbr />,4),mid(&quot;2<wbr />0100106&quot;, 7, 2),mid(&quot;20100106&quot;,5,2))<br />
<br />
Replacing the string with your variable three times of course<br />
<br />
Regards,<br />
<br />
chris_bottomley
</div>


Hello badgermike,

I presume:

dateserial(left("20100106",4),mid("20100106", 7, 2),mid("20100106",5,2))

Replacing the string with your variable three times of course

Regards,

chris_bottomley

<div>
Easy enough ... second time around. &nbsp;Would have been easy if I was clever!<br />
<br />
Chris
</div>


Easy enough ... second time around.  Would have been easy if I was clever!

Chris

<div>
<div class="content wysiwyg-content">
I am tring to create a Vbscript that takes a variable from our accounting software. The date that is coming in from the accounting software, not sure which format, but today reads as: 20100106<br />
<br />
I want to convert that to go into outlooks duedate field...I notice the outlook date displays as Wed 1/6/2010<br />
<br />
anyone have a formula that will convert the accounting software date to a format that outlook can use?<br />
<br />

</div>
</div>


I am tring to create a Vbscript that takes a variable from our accounting software. The date that is coming in from the accounting software, not sure which format, but today reads as: 20100106

I want to convert that to go into outlooks duedate field...I notice the outlook date displays as Wed 1/6/2010

anyone have a formula that will convert the accounting software date to a format that outlook can use?



Pushing A Date To Outlook Via Vbscript

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Microsoft Outlook is a personal information manager from Microsoft, available as a part of the Microsoft Office suite. Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note-taker, journal, and web browser.