Date Format Error

Good Morning!

Can someone help with this? I am receiving a Run-Time Error 13 - Type Mismatch.

Code:

---

thisdate = Int(Now)
revdate = Format(thisdate, "m/d/yy")

---

It doesn't like the format. I originally was using "dd" which worked fine but now need the full date.

Thank you,
Donna

Perhaps :

Code:

---

Dim revdate As Date
revdate = Format(Now, "m/d/yy")

---

Charlize

Duh...had it as double. Thank you!

Quote:

---

Originally Posted by Charlize

Perhaps :
[vba]Dim revdate As Date
revdate = Format(Now, "m/d/yy")[/vba] Charlize

---

Surely, revdate is a string here, and why use Now

[vba]

Dim revdate As String

revdate = Format(Date, "m/d/yy")
[/vba]

Quote:

---

Originally Posted by xld

Surely, revdate is a string here, and why use Now

Code:

---

Dim revdate As String
revdate = Format(Date, "m/d/yy")

---

---

Surely ? I don't know. Can't read the mind. Don't know what the poster wanted to do.
Why Now. The poster used it so I just took it over without further thinking about it.

Charlize