InfoPath Dev

Figured it out... I used this formula to define the default value of the date picker control : addDays(today(), -((number(substring(today(), 9, 2)) + 1))) This takes today's date (Oct 25th) , and deducts the number of days passed in the current month (25), plus one extra (i.e. 26) Thus returning the last day of the previous month (i.e. Sep ...

Hi all, Does anybody know if/how it is possible to set a datepicker control value to default to the previous month? So, for example, if someone were to open the form today (Oct 25th), the datepicker would default to Sep 25th? (The exact date isn't important - I'm really only concerned with the month - so any date in September would ...

Many thanks Gennady! Agree on the advice to avoid coding where possible; I've managed to utilise an elaborate formula to apply a rule / data validation combo to force users to only select a Friday on a date-picker. Link below for anyone else with the same requirement ...

Hi all, Have been browsing for this already and suspect it is either a) impossible or b) quite complicated to achieve, but figured it's no harm to ask anyway... I'm designing a form template which will have multiple sections based on daily, weekly or monthly data. Above each section I have a date picker to allow the user to specify ...

Hi Gennady, Thanks for the reply. Still confused though? How can I pull data stored on a submitted form on a SharePoint site, into an Access database which is not? Thanks Al

Hi all, Newly introduced to the wonders of InfoPath and hoping it can form part of a solution for me - apologies in advance if I am posting inappropriately... I'm hoping to use InfoPath to collaborate data by publishing form templates on a SharePoint site. Users will populate & submit forms on the SharePoint on a daily basis. Submissions ...