InfoPath Dev

substring(date, 1, 19) where date is your date field, should provide you with the value without the fractional seconds.  Just use that in a rule.

 If you use Infopath Client, here a some C# code to know the major version of office: using Microsoft.Office.Interop; string sVersion = string.Empty;             Microsoft.Office.Interop.Word.Application oApp = new ...

The process would still work. Any idea how to lop off the fractional seconds. Thanks for the reply

Here is the resource you might find useful: http://alecpojidaev.wordpress.com/2010/01/07/accessing-previous-rows-in-repeating-group-for-browser-enabled-forms/

But can it be used without modifying the existing schema? For the one form that is an absolute requirement.

I think SQL server doesn't like the .160000000 part at the end.  Would your process still work if you lopped off the fractional seconds part at the end before doing your query?  It seems like SQL Server will probably accept up to 3 digits of fractional seconds.

I have created security form library for Mgrs to add data - works great and I want to be able to print a formatted form with the fields that have been collected from the IP security form.  Not sure what to do?  Form Action link that would print another IP form with the fields being pulled from the initial seurity form or Can ...

[0x80040E07][Microsoft OLE DB Provider for SQL Server] Conversion failed when converting datetime from character string. Hi, Can someone help me please with the above problem. I'm new to InfoPath and i'm trying to make a form that goes into out inventory database (MS-SQL 2005). I have every thing working except this query. The Idea ...

Hi--I've no experience at all with InfoPath or Access, but was given the 2010 editions of both and am going crazy trying to figure out why my simple initial test won't work!  Sorry if this is more of an Access issue than InfoPath, but I'd be incredibly grateful for any help or insight anyone can provide. So what I'm doing is ...