Sure. I don't see why not. Use DateSerial to put together 1/1 of the current year. Use DateDiff to determine how many days from then until now. Use Format to assemble the current date/time as you want it. Then smash em all together. :)
Just use the Format function. If you finish this entire class and still have questions, let me know. DateSerial is a great function.
Austin Ritner 2 years ago
Finally had some time to really work on this. It was super easy. The only thing I had an issue with at first was formatting the time because it was displaying the AM/PM, but as soon as I put Format([Time], "hhnnss") into the control source tab, it worked flawlessly.
So now it displays as days passed since 1/1, mmddyy, hhnnss, and autonumber (293)-(090920)(093342)(1)