julian date

D

David

Hi Everyone,

I want to have in a report a three digit julian day followed by a one
digit year. I have this function =Format(DatePart("y",Date()),"000") &
Format(Date(),"yy") but it shows a two digit year. Any thoughts? So
today 2/10/05 it would show 0415.

TIA,
David
 
A

Andi Mayer

Hi Everyone,

I want to have in a report a three digit julian day followed by a one
digit year. I have this function =Format(DatePart("y",Date()),"000") &
Format(Date(),"yy") but it shows a two digit year. Any thoughts? So
today 2/10/05 it would show 0415.

TIA,
David
Click to expand...

right(Format(Date(),"yy",1)
 
Top