InfoPath 2010

Re: InfoPath 2010 Formula for Julian Day (###)

donstephen — Fri, 17 Jul 2015 02:10:16 GMT

Hi Greg,

The Julian Day formula i found had a longer length, adding all these C+D+E+F-1524.5. Anyway, this is a good formula. Thank you for posting this.

Re: InfoPath 2010 Formula for Julian Day (###)

MeekerGBT — Thu, 16 Jul 2015 19:39:31 GMT

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) + (substring-before(now(), "-") + 4800 - (floor((14 - substring-before(substring-after(now(), "-"), "-")) / 12))) * 365 + floor((substring-before(now(), "-") + 4800 - (floor((14 - substring-before(substring-after(now(), "-"), "-")) / 12))) / 4) - floor((substring-before(now(), "-") + 4800 - (floor((14 - substring-before(substring-after(now(), "-"), "-")) / 12))) / 100) + floor((substring-before(now(), "-") + 4800 - (floor((14 - substring-before(substring-after(now(), "-"), "-")) / 12))) / 400) - 32045) - ((substring-before(substring-after(substring-after(concat(string(substring(today(), 1, 4)), "-01-01T00:00:00"), "-"), "-"), "T")) + floor((153 * ((substring-before(substring-after(concat(string(substring(today(), 1, 4)), "-01-01T00:00:00"), "-"), "-")) + 12 * (floor((14 - substring-before(substring-after(concat(string(substring(today(), 1, 4)), "-01-01T00:00:00"), "-"), "-")) / 12)) - 3) + 2) / 5) + (substring-before(concat(string(substring(today(), 1, 4)), "-01-01T00:00:00"), "-") + 4800 - (floor((14 - substring-before(substring-after(concat(string(substring(today(), 1, 4)), "-01-01T00:00:00"), "-"), "-")) / 12))) * 365 + floor((substring-before(concat(string(substring(today(), 1, 4)), "-01-01T00:00:00"), "-") + 4800 - (floor((14 - substring-before(substring-after(concat(string(substring(today(), 1, 4)), "-01-01T00:00:00"), "-"), "-")) / 12))) / 4) - floor((substring-before(concat(string(substring(today(), 1, 4)), "-01-01T00:00:00"), "-") + 4800 - (floor((14 - substring-before(substring-after(concat(string(substring(today(), 1, 4)), "-01-01T00:00:00"), "-"), "-")) / 12))) / 100) + floor((substring-before(concat(string(substring(today(), 1, 4)), "-01-01T00:00:00"), "-") + 4800 - (floor((14 - substring-before(substring-after(concat(string(substring(today(), 1, 4)), "-01-01T00:00:00"), "-"), "-")) / 12))) / 400) - 32045) + 1)

Re: InfoPath 2010 Formula for Julian Day (###)

MeekerGBT — Wed, 15 Jul 2015 13:13:26 GMT

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 correct result. that might be Julian DATE. IDK...

Thanks for taking time to help out.

Greg

Re: InfoPath 2010 Formula for Julian Day (###)

donstephen — Mon, 13 Jul 2015 04:41:39 GMT

Hi Greg,

I was attempting to find a Julian Day formula so I could create one for you, but I wanted to verify first if this would be the correct formula:

A = Y/100
B = A/4
C = 2-A+B
E = 365.25x(Y+4716)
F = 30.6001x(M+1)
JD= C+D+E+F-1524.5

Thanks,

InfoPath 2010 Formula for Julian Day (###)

MeekerGBT — Tue, 07 Jul 2015 17:37:19 GMT

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 into.

Thanks...