Getting Julian day

[Manoj_KumarBeva]

Hi Guys, How can I get the Julian day in blue prism without using code stage Thanks in advance for your help

[david.l.morris]

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

[Manoj_KumarBeva]

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

[david.l.morris]

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

[Manoj_KumarBeva]

Hi David,   I am most thankful to you for providing me the solution