I have a Form in which a user enters a date value into a text box in the format of mmddyyyy
In my VBA code, I then parse the information as follows:
StartDate = Format(CDate(Left([StartDate], 2) & "/" & Mid([StartDate], 3, 2) & "/" & Right([StartDate], 4)), "MM/DD/YYYY")
Now, I have the start date in a string in the format I want. I can MsgBox the date, I can use it as a filter in a Report, BUT I CANNOT GET THIS DATE TO APPEAR IN MY ACCESS REPORT (the capitalized words describe my problem/question)
I have a control box on my Report and I assign 'Start Date' as the Control Source, but the date field displays as #Error in my report no matter what I do - HELP!