Hello all, What are the date functions in VBA? I have a string in my Access 2000 code, and I'd like it to hold today's date. What do I call to get the date? Dim theDate as string theDate = date() I know that is wrong, but what do I do? Thanks Nick
Hello all, What are the date functions in VBA? I have a string in my Access 2000 code, and I'd like it to hold today's date. What do I call to get the date? Dim theDate as string theDate = date() I know that is wrong, but what do I do? Thanks Nick
In VBA/MS Access Macro code, something like this should place today's date into a string: Dim myDate As Date Dim myDateString As String myDate = Date myDateString = CStr(myDate) MsgBox myDateString Hope that helps.
