InfoPath Dev

 Formula for Julian Day:   (((substring-before(substring-after(substring-after(now(), "-"), "-"), "T")) + floor((153 * ((substring-before(substring-after(now(), "-"), "-")) + 12 * (floor((14 - substring-before(substring-after(now(), "-"), "-")) / 12)) - 3) + 2) / 5) ...

 Don, The Julian day is a three digit number. so Jan 1st. is 001 and December 31st. is 365. I use a combination of YEAR/JulianDay/UserID/Seconds in sharePoint to help automate document control numbers.  I want to do the same in InfoPath. So looking at your formula, it would appear that the 1524.5 is not the ...

Don, Thank you for taking the time to reply. I work in a network environment where videos are restricted. it's one of my biggest frustrations. That is why I asked for detailed instruction. Plus, I hope detailed instructions will help others. To many post often assume knowledge and although helpful ...

 I solved the problem. I will try to update the steps next time I post.

Problem: Unable to configure my InfoPath form to display the "Required Documents" when the "Action Requested" drop-down list (Action) is selected?  FACTs:  I am using InfoPath 2010 with SharePoint 2007. I have a list in SharePoint named  "Action Requested: with the following ...

So I am searching for an InfoPath 2010 formula for Julian Day. That is to say the resulting value for January 1, 2015 would look something like this "001" I am new to InfoPath and would appreciate a formula that is Copy and Paste ready. I have created a TXT box named "Julian" in which I plan to paste the formula ...