Code

Re: Function for working with julian dates

KansasCoder — Wed, 05 Jan 2011 15:20:32 GMT

If interested more on this, including a SQL Server UDF, is available my tiny blog

Re: Function for working with julian dates

KansasCoder — Fri, 01 Oct 2010 15:54:19 GMT

I figured it out. In case anyone else needs this odd requirement fulfilled here is the way to do it in XSLT:

(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

This will round up the ones place.

Optimizations are welcome!

XSLT Function to get julian day of the year

KansasCoder — Fri, 01 Oct 2010 15:52:05 GMT

I just started in InfoPath yesterday and I've nver worked with Julian Dates so bear with me if this is covered all over the web. I wasn't able to find anything.

I am working in InfoPath 2007. I have a field which I need to auto populate with a numeric value with YYYY + day of the year in Julian.

Is there an xslt function that cane take the current system date as an input and kick back the julian day part of the result?

Thank yoU!