try:



juliandate = right(year(NOW),2)

juliandate = juliandate & DateDiff("d","01/01/" & year(NOW),NOW)



will give you yyddd format.  if you just need ddd, omit the first line.  

or if you need yyyyddd, then omit right(  ,2)