If you want to format a date to a specific date format, like dd-MM-YYYY in Microsoft Excel VBA, use: Dim specificFormatedString as String specificFormatedString = Format(Date,"DD-MM-YYYY")
To resolve collation conflicts like: Msg 468, Level 16, State 9, Line 135 Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation. You should surround the ‘=’ with collate database_default
> Start you’re webservice > Start Microsoft Office Excel > Show the Control Toolbox toolbar: > View > Toolbars > Control Toolbox > Enter Design mode by clicking the “Design Mode” button on the Control