Julian date

Chris Savedge · Jul 28, 2004

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

Michel Walsh · Jul 28, 2004

Hi,

Using Access 2003:

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

Hoping it may help,
Vanderghast, Access MVP

Chris Savedge · Jul 28, 2004

Thanks so much Michel.

Michel Walsh said:
Hi,

Using Access 2003:

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

Hoping it may help,
Vanderghast, Access MVP