<div>
Post your complete script and the sample data text file. It seems that you If condition is not correct. E.g. number of spaces. Maybe there are trailing or leading spaces. Or milliseconds.
</div>


Post your complete script and the sample data text file. It seems that you If condition is not correct. E.g. number of spaces. Maybe there are trailing or leading spaces. Or milliseconds.

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
My script reads a text file that contains a datetime. Within the script I have a varible called strFieldData whch stores a datetime value.<br />
<br />
Sometimes 99.99.99&lt;2 white spaces&gt;99:99:99 (date time) has been entered which is not valid date and time for the program that recieves this value.<br />
<br />
I tried to convert this value using the Now function but its still keeping the same value:<br />
<br />
If strFieldData = &quot;99.99.99 &nbsp;99:99:99&quot; then <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;strFieldData = Now<br />
Still returns 99.99.99 &nbsp;99:99:99<br />
<br />
Is there another way i can conert this value to the server date time?
</div>
</div>


Hi

My script reads a text file that contains a datetime. Within the script I have a varible called strFieldData whch stores a datetime value.

Sometimes 99.99.99<2 white spaces>99:99:99 (date time) has been entered which is not valid date and time for the program that recieves this value.

I tried to convert this value using the Now function but its still keeping the same value:

If strFieldData = "99.99.99  99:99:99" then 
                     strFieldData = Now
Still returns 99.99.99  99:99:99

Is there another way i can conert this value to the server date time?

Vb Script change none date time value to valid date time

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.