Thanks for the response. I have read the article that you referenced in your answer to my original post, and I have created the below function to convert a long date to a short date.
But, how do I get the dates to appear in my report as a short date (date only no time portion)? I need each date for each record in the database that appears on the report to appear as a short date in the "mm/dd/yyyy" format. How do I use the below function to convert the dates so they don't have the time portion? There must be something simple that I am overlooking.
Any help in this matter will be greatly appreciated.
Public Function DateShort(ByVal Mydate As Date) As String
Mydate = Mydate.ToString("d")
Return Mydate
End Function