https://community.blueprism.com/t5/Product-Forum/Getting-Julian-day/m-p/64440#M17218 Hi Manoj, Are you looking for the format that has decimals in it or a whole number? And are you referring to the day number since the beginning of the current year or the day number since January 1, 4713 BC? Respectfully, Dave Wed, 26 Sep 2018 07:08:00 GMT david.l.morris 2018-09-26T07:08:00Z https://community.blueprism.com/t5/Product-Forum/Getting-Julian-day/m-p/64439#M17217 Hi Guys, How can I get the Julian day in blue prism without using code stage Thanks in advance for your help Tue, 25 Sep 2018 20:07:00 GMT https://community.blueprism.com/t5/Product-Forum/Getting-Julian-day/m-p/64439#M17217 Manoj_KumarBeva 2018-09-25T20:07:00Z https://community.blueprism.com/t5/Product-Forum/Getting-Julian-day/m-p/64440#M17218 Hi Manoj, Are you looking for the format that has decimals in it or a whole number? And are you referring to the day number since the beginning of the current year or the day number since January 1, 4713 BC? Respectfully, Dave Wed, 26 Sep 2018 07:08:00 GMT https://community.blueprism.com/t5/Product-Forum/Getting-Julian-day/m-p/64440#M17218 david.l.morris 2018-09-26T07:08:00Z https://community.blueprism.com/t5/Product-Forum/Getting-Julian-day/m-p/64441#M17219 Hi david, Thanks for your quick response sorry for the delay response, I need the day of the year for example if it is March 1st then it should return (31 Jan + 28 Feb) = 60   Thank you Mon, 08 Oct 2018 16:03:00 GMT https://community.blueprism.com/t5/Product-Forum/Getting-Julian-day/m-p/64441#M17219 Manoj_KumarBeva 2018-10-08T16:03:00Z https://community.blueprism.com/t5/Product-Forum/Getting-Julian-day/m-p/64442#M17220 Hi Manoj, Try this out: ToDays(ToDateTime(Today())-ToDateTime(""1/1/"" & FormatDateTime(Today(),""yyyy""))+MakeTimeSpan(1,0,0,0)) Replace the first Today() with a date if you're not using today like this: ToDays(ToDateTime(""10/1/2018"")-ToDateTime(""1/1/"" & FormatDateTime(Today(),""yyyy""))+MakeTimeSpan(1,0,0,0)) Respectfully, Dave Mon, 08 Oct 2018 18:04:00 GMT https://community.blueprism.com/t5/Product-Forum/Getting-Julian-day/m-p/64442#M17220 david.l.morris 2018-10-08T18:04:00Z https://community.blueprism.com/t5/Product-Forum/Getting-Julian-day/m-p/64443#M17221 Hi David,   I am most thankful to you for providing me the solution Wed, 10 Oct 2018 19:32:00 GMT https://community.blueprism.com/t5/Product-Forum/Getting-Julian-day/m-p/64443#M17221 Manoj_KumarBeva 2018-10-10T19:32:00Z