Dates

What is the function for changing a date in the date/time format to just the date format without a time?

Format("mm-dd-yyyy")

You forgot the Date argument: :)

Code:

---

Debug.Print Format(Date, "mm-dd-yyyy")

---

Oops! Sorry. :-)

I won't work in .NET, but in 6.0 you can use:

Code:

---

MyDate = Int(MyDateTime)

---