days between dates and sql server data base

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paulo Pina - 18 Apr 2006 11:08 GMT

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

Reply to this Message

Adam Harding - 18 Apr 2006 15:58 GMT

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

> Hi,
>
[quoted text clipped - 9 lines]
>
> Paulo Pina

Reply to this Message

Adam Harding - 18 Apr 2006 16:08 GMT

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

> Hi,
>
[quoted text clipped - 9 lines]
>
> Paulo Pina

Reply to this Message