InfoPath Dev

I managed to get this sorted :) Thanks or the help Hilary :)

Hi Hilary, thanks for your reply. Yes the Xpath filter comparing "my:MonDate" with "@CreateDate". The date formats are correct, as they are both dd/mm/yyyy. Yeah the SQL database holds the time value as well, but in a separate field with in @CreateDate. I have tried use both a text field set to a whole number and a calculated ...

Hello, I am trying to count a field based on a date. So I have a SQL database which holds data, in that data we have a status field. We are trying to use a calculated value to count the instance of the data depending if the create date matches a selected date and if two instances of the field match. Here is what I have so ...

Found a solution: https://www.youtube.com/watch?v=g-25loJirGQ

Hi, I am having a bit of an issue with my form. I have built a dashboard for gathering stats from a SQL database. I have created a multiple selection list box and repeating table linked to SQL database. My issue is as follows: The repeating table displays incident data from the SQL database. So will show multiple lines of data in repeating ...