Posted by Donk on February 01, 1999 at 00:19:31:
Pleeeeeeeeeeeeeeaaaaaaaaaase help me. I'm trying to express an Access97 field(using VB) to express the Date Value as the day of the year. In other words, instead of, say Feb 2, 1999, I 'd get "Day =32" becuase Feb 2nd happens to be the 32nd day of the 365 day year. How do I express this? I know it's not as simple as =Format(#mm-dd-yy#), so can someone please help. None of my books address this and I really need it.