InfoPath Dev

Hi guys I want a field that calculates the difference between 2 dates (date pickers). The following link details a lengthy way of getting this: http://www.bizsupportonline.net/infopath2007/calculate-date-difference-infopath-rules-formulas.htm But I only want to calculate working days. Anyone know a way of achieving this? Thanks :)

Thank you so much Hilary! Sorry for the delayed response - been on holiday for 2 weeks. The form works great thank you so so much :)

It's ok! I want my filenames to be auto numbered. So the filename would be something like 'Request - 1' then the next would automatically be 'Request - 2' etc The link I provided enables me to do that - but then gives me other problems that I can't figure out. So I'm after a method like you suggested - a field that ...

So 'SharePoint Library Submit' was my own original library submit. So this gives a file name of date - field number 'Main submit' is the library submit that was suggested by the link I've included in the posts. You may find it easier just to use my original form which only has my original data connection in (Book Orders 3 ...

This file attached is my file before I started to mess around with the auto numbering if anyone knows how to do auto numbering then is a 'fresh' form to start from.

Hi Hilary Wow thank you for the offer. I've attached the form. So the form attached has the workaround provided by: http://www.bizsupportonline.net/browserforms/autonumber-infopath-form-submitted-sharepoint-library.htm So in data connections you will see 'Main submit' and 'RetrieveIDs' which are both needed for the ...

Hi Hilary, Thanks for this. I've spent all of this time since you posted trying to do what you suggested but I can't - I just keep getting errors. Sorry to be a pain - I'm no expert :( Can anyone explain exactly what I need to do this? What Hilary suggests above is exactly what I want. A field that auto populates depending on ...

Hi guys I followed the guide here: http://www.bizsupportonline.net/browserforms/autonumber-infopath-form-submitted-sharepoint-library.htm To create a filename that auto generates sequentially (that's what I need). It works fine - but - I can't work out how to then open the form and makes changes to it...and then save it again. ...

Thank you Hilary. I've since found this: link But I don't understand what 'Flag Fields' are. Do you know what they are and how I'd create one? Thanks :)

Hi guys I have a large form and I'd love to know when opening the form which field has been edited or completed for the first time - without me having to look at all of the fields to try and spot it. Therefore I'm trying to figure out a way of highlighting a field that has been edited. I was thinking of adding some formula like "if ...