0:30:00&quot;<br>&quot;January 25, 1996 8:30:00&quot;<br>&quot;8:30:00 Jan. 25, 1996&quot;<br>&quot;1/25/1996 8:30:00&quot; // always specify the full year, even in a 'short date' format.<br>Note that the locale ID will also affect whether the string format is acceptable for conversion to a date/time value. In the case of VAR_DATEVALUEONLY, the time value is set to time 0, or midnight. In the case of VAR_TIMEVALUEONLY, the date value is set to date 0, meaning 30 December 1899.</td>
</tr>
<tr class="even">
<