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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Julian Date Question (Another) 4
Calculating a Julian Date 7
Julian date question 6
Converting Date to Julian 4
Three Digit Julian Date 4
converting julian Date to Database date 5
Strange Julian Date Phenomenon 9
How do I get the date to display a Julian date? (yyddd) 2

Top