Newbie Questions

Re: Reset project number if it's the start of a new month.

Samir Farid — Wed, 29 Apr 2009 23:37:08 GMT

Brett,

The only possible way I can think of is trying to store a variable in a file outside InfoPath. Xml would probably be the best. Then you can use a Secodary Data Source to receive data from that xml file and check the variable. For example, if the variable is True then a project has already been updated with a new project ID.

Regards,

Samir

Re: Reset project number if it's the start of a new month.

bsmith — Wed, 29 Apr 2009 17:07:58 GMT

Hello Samir,

Thank you for your reply. Yes, that will work except for one issue, if I add that rule it will reset the counter for every project opened that day. I need some way to tell it to only do it for the first document opened that day.

Thanks,

Brett

Re: Reset project number if it's the start of a new month.

Samir Farid — Wed, 29 Apr 2009 16:57:18 GMT

Hey Brett,

Can't you just get today's date and check whether the day value is 1. If it is 1 then you reset your counter.

This function will get the day for you.

substring(xdDate:Today(), 9, 2)

Regards,

Samir

Reset project number if it's the start of a new month.

bsmith — Mon, 27 Apr 2009 03:20:37 GMT

Hello again,

Thanks in advance for any help on this one.

I have a form in which I create the project ID based on the last two digits of the year, then the month, and then a three digit incremental counter, all concatenated. So a form entered on April 24th would be 0904017 if 16 other forms have already been created in April. Now, the incremental counter needs to reset back to 1 at the beginning of a new month and I am having some trouble getting this to work. So the first project entered in May should reset to 0905001.

Is there any function to subtract a month in xddate? I know that you can use xddate:adddays(date, x) to add days, but I need to subtract the month to see if the last project ID was for last month or not.

Anybody have any suggestions on resetting this counter effectively?

Thanks for your help,

Brett