Getting today's date

[xstopx81]

how do you get today's date, and what day today is. I'm pretty sure there's a simple way to find this out. The information I need is the month, date, year and the day of the week, like sunday or monday... help needed asap

Try:

Retval = Format(Date, "dddd dd/mm/yyyy")
MsgBox (Retval)

Use the Format function to do it.

MsgBox "Today is: " & Format$(Date, "Long Date")

[xstopx81]

hey thanks for replying... i found out how to get the dates... i can just use month(date), year(date) and day(date)