Combining 2 dates to make 1 date (1 Viewer)

sloaner14

Registered User.
Local time
Today, 20:38
Joined
Apr 25, 2002
Messages
32
Why does this not work for me?:confused:

I get r-t error '13': Type Mismatch

*** datDate is from a DAO.Recordset rs!LastUpdate ***

NewDate = Month(Date) & "/" & Day(datDate) & "/" & Year(Date)

But this works.:mad:

NewDate = Month(datDate) & "/" & Day(datDate) & "/" & Year(Date)

Thanks for any advice or help that you can give me. I have never been let down by the help I recieve here. Thanks a million!!!:)
 

raskew

AWF VIP
Local time
Today, 15:38
Joined
Jun 2, 2001
Messages
2,734
Hi -

Lookup the DateSerial() function. Suspect that you're attempting to take a valid date/time data type and turning it into a string, thus the type mismatch.

Bob
 

sloaner14

Registered User.
Local time
Today, 20:38
Joined
Apr 25, 2002
Messages
32
Life Saver

Thanks a million!!! I was ready to pull my hair out. I knew that it was something in my data type, but could not figure it out. I tried cdate and everything I could think of, but I never used DateSerial and poof it worked. I knew it was something simple.

Thank you very much!!!

Wes
 

Users who are viewing this thread

Top Bottom