Ordinal Date (only month/day)

[EverydayDiesel]

How can I create a ordinal date just using month/day only?

All the examples I see have month,date,and year.

[Phil Weber]

You can't. A date consists of a year, a month and a day. Can you provide more details about why you want to do this?

[gibra]

A Date match a unique Time event.
Therefore a field Date (DateTime) is really compose by :

Month + Day + Year + Hour + Minute + Second

You can decide to use DateTime data type, but to show only part of it, using related functions like Format(), DatePart(), ecc...

If you want manage and store only Month and Year, then you use a DateTime field type.

You must store the month/year in a TEXT data type.

HTH

[EverydayDiesel]

They are trying to make a small footprint date. (it wasnt my idea)

This is what im trying to create. A program that will write this easily. I know it can be done

http://www.fs.fed.us/raws/book/julian.shtml

[Hack]

So basically you are just looking for the day of the year, right.

(i.e., 4/9 = the 99th day of the year) Try this

Dim intDayOfYear As Integer
intDayOfYear = DatePart("y", Now)
Msgbox intDayOfYear

[EverydayDiesel]

So basically you are just looking for the day of the year, right.

(i.e., 4/9 = the 99th day of the year) Try this

Dim intDayOfYear As Integer
intDayOfYear = DatePart("y", Now)
Msgbox intDayOfYear

Thats the one... Thanks!!!!