Julian date

C

Chris Savedge

How can I format the Date() function to produce a julian date. For example:
I want 7/27/04 to look like 04209. Any suggestions?

Thanks,
Chris
 
M

Michel Walsh

Hi,

Using Access 2003:

? Format(Date(), "yyy")
04210



Hoping it may help,
Vanderghast, Access MVP
 

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 to Short Form 3
Use excel to calculate an expiration date 1
Convert Date to Julian Date 2
Force date field update upon printing 0
Strange Julian Date Phenomenon 10
Is there a calender preference for Julian Dates in outlook? 1
Countdown macro - display settings 2
How do I get the date to display a Julian date? (yyddd) 2

Top