Here's my code:
I get the failure on the last line. "Type mismatch". Is there something wrong with the way I'm defining my testDate value?Code:Dim testDate As Date testDate = #1/16/2012# 'Get last day of month daysInMonth = Day(DateAdd("m", 1, testDate - Day(testDate) + 1) - 1) outputDate= CDate(Month(testDate) & "/" & daysInMonth & "/" & testDate)
Thank you.
Edit: Just found the error. Very silly error. Feel free to delete this thread.