InfoPath Dev

Hi All

I have a form containing both rules and code

When the form is created it sets the creation date according to a rule in form open behaviour:

"Set a fields value: CreatedWhen = now".

 This sets the time correctly

 

The same form has some C# code:

//record time date and user updated

string s;

DateTime now = DateTime.Now;

s = "Updated: " + now.ToString("U",culture) + " by: " + System.Environment.UserName;

sSetField("CommentTotalAll", s);  //This just writes the string to a text field using an XPath Navigator

 

The trouble is that the date set by the code is one hour behind in relation to the computers time, while the time set by rules is correct. Does anyone know why this could be? (I've tried changing the culture, that made no difference)

 Thanks

Trevor

 

Are you one timezone away from England?  The "U" format string produces UTF time so that would explain the discrepancy.  For local time, you can just use DateTime.Now.ToString().

Yes that fixed it thanks

I thought the U was just formatting