days between dates and sql server data base

[Paulo Pina]

Hi,

I have implemented the VBScript
(http://enterprise-solutions.swits.net/infopath/datediff-vbscript-infopath.htm)
in a New Blank Form, and it's works. But when I use a New Form with a SQL
Server Data Base connection, the difference between dates not works, I don't
have any results.

Someone can help?

Thanks in advance,

Paulo Pina

 

[Adam Harding]

Hi

In tools, form options, open and save, untick save and save as, then have a
button on your form to save the form, which only saves it to the UNC path you
give it. This will have to be done through code. Fairly simple but look
through this board to find out how.

Cheers Adam

 

[Adam Harding]

I think it depends on the formatting of the date in SQL, perhaps you have to
specify the fields to be in XML on the form and text in the database not date
or time. Furthermore, you may need a different SQL function to compare the
values if it pulls back the reuslt of a query.

I hope this helps

Adam