<div>
yes, but for some reason it doesn't convert that way. thinks it's am even thought it's greater then 12
</div>


<div>
How do you check it is 'am' ?
</div>


<div>
the time format would look something like <br />
<br />
13:30 = 1:30 pm<br />
<br />
or <br />
<br />
04:30 = 4:40 am<br />
<br />
so I guess one way would be to parse it and do an if then saying<br />
if &gt;&nbsp;12 then<br />
&nbsp; &nbsp; pm<br />
else<br />
&nbsp; &nbsp; am<br />
end if<br />
<br />
but I would think there would be a better way
</div>


<div>
How do you check it is 'am' ? &nbsp;By that I mean after the value is converted.
</div>


<div>
Do I understand correctly<br />
given a value eg. <i> time = &quot;02/28/2011 13:45&quot;</i><br />
then after the FormatDateTime you have &nbsp; <i>timeStandard shows something like &quot;02/28/2011 1:45&quot;</i>
</div>


<div>
close<br />
<br />
would look like <br />
&quot;02/28/2011 1:45 pm&quot;<br />
<br />
but when it converts, it makes it an am
</div>


<div>
so time = &quot;02/28/2011 13:45&quot; ==&gt; &nbsp;&quot;02/28/2011 1:45 am&quot;<br />
<br />
What happens when you use &quot;#02/28/2011 13:45#&quot;, does that make any difference?
</div>


<div>
it inserts the way it is by an obout.com datetime picker control.<br />
<br />
that's why I need to convert it in the itemupdating
</div>


<div>
It should be simple to add the lead and trailing # symbols to test - <b>if </b>it then works correctly :-)
</div>


<div>
this is what happens on insert<br />
<br />
Conversion from string &quot;04/01/2011 20:07#&quot; to type 'Date' is not valid.
</div>


<div>
#symbols both at start and end of the string<br />
<br />
&quot;<b>#</b>04/01/2011 20:07#&quot;
</div>


<div>
Hmmm.<br />
<br />
The only thing I notice (assuming the time in the example is your current time - pm) is that GMT is currently morning - am.<br />
<br />
Could you hard code it as &quot;04/01/2011 08:07&quot; and see if that appears correctly OR if it is converting it to pm. &nbsp;
</div>


<div>
it looks like in the database, if it's read to a weboage 04/01/2011 08:07 would show as pm.<br />
<br />
but when I do an update to the field, it resaves as am
</div>


<div>
Am I correct.<br />
It is displaying 'am' values as 'pm' and in reverse ?<br />
<br />

</div>


<div>
what happens is, I do an insert.<br />
<br />
everything is fine. &nbsp;then I do an update and when it updates, it switches from pm to am on update.<br />
<br />

</div>


<div>
<div class="content wysiwyg-content">
I'm trying to do a simple conversion from military time to standard time<br />
<br />
basically a simple<br />
<br />
Dim time = e.OldValues(&quot;TimeOccured&quot;)<wbr /><br />
Dim timeStandard = FormatDateTime(time, DateFormat.GeneralDate))<br />
<br />
Time being = MM/dd/yyyy hh:mm<br />
<br />
the problem I am having is when it converts, it can't distinguish between am or pm
</div>
</div>


I'm trying to do a simple conversion from military time to standard time

basically a simple

Dim time = e.OldValues("TimeOccured")
Dim timeStandard = FormatDateTime(time, DateFormat.GeneralDate))

Time being = MM/dd/yyyy hh:mm

the problem I am having is when it converts, it can't distinguish between am or pm

?
when hh is more than 12 then it is pm else it is am

yes, but for some reason it doesn&#39;t convert that way. thinks it&#39;s am even thought it&#39;s greater then 12

the time format would look something like 

13:30 = 1:30 pm

or 

04:30 = 4:40 am

so I guess one way would be to parse it and do an if then saying
if &gt; 12 then
    pm
else
    am
end if

but I would think there would be a better way

How do you check it is &#39;am&#39; ?  By that I mean after the value is converted.

Do I understand correctly
given a value eg.  time = &quot;02/28/2011 13:45&quot;
then after the FormatDateTime you have   timeStandard shows something like &quot;02/28/2011 1:45&quot;

close

would look like 
&quot;02/28/2011 1:45 pm&quot;

but when it converts, it makes it an am

so time = &quot;02/28/2011 13:45&quot; ==&gt;  &quot;02/28/2011 1:45 am&quot;

What happens when you use &quot;#02/28/2011 13:45#&quot;, does that make any difference?

it inserts the way it is by an obout.com datetime picker control.

that&#39;s why I need to convert it in the itemupdating

It should be simple to add the lead and trailing # symbols to test - if it then works correctly :-)

this is what happens on insert

Conversion from string &quot;04/01/2011 20:07#&quot; to type &#39;Date&#39; is not valid.

#symbols both at start and end of the string

&quot;#04/01/2011 20:07#&quot;

Hmmm.

The only thing I notice (assuming the time in the example is your current time - pm) is that GMT is currently morning - am.

Could you hard code it as &quot;04/01/2011 08:07&quot; and see if that appears correctly OR if it is converting it to pm.  

it looks like in the database, if it&#39;s read to a weboage 04/01/2011 08:07 would show as pm.

but when I do an update to the field, it resaves as am

Am I correct.
It is displaying &#39;am&#39; values as &#39;pm&#39; and in reverse ?



what happens is, I do an insert.

everything is fine.  then I do an update and when it updates, it switches from pm to am on update.



Military to standart time conversion

I&#39;m trying to do a simple conversion from military time to standard time

basically a simple

Dim time = e.OldValues(&quot;TimeOccured&quot;)
Dim timeStandard = FormatDateTime(time, DateFormat.GeneralDate))

Time being = MM/dd/yyyy hh:mm

the problem I am having is when it converts, it can&#39;t distinguish between am or pm

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

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.

VB Script

Microsoft Visual C++ (often abbreviated as MSVC or VC++) is an integrated development environment (IDE) product from Microsoft for the C, C++, and C++/CLI programming languages. It features tools for developing and debugging C++ code, especially code written for the Microsoft Windows API, the DirectX API, and the Microsoft .NET Framework. Many applications require redistributable Visual C++ packages to function correctly and are often installed independently of applications, allowing multiple applications to make use of the package while only having to install it once