date issues

Results 1 to 2 of 2

Thread: date issues

  1. #1
    yls Guest

    Default date issues

    MaidWorkPermitExpireDate = #" & myworkpermit & "# <BR><BR>is the # also recognized in sql server? thanks <BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: date issues

    No, SQL Server expects dates to be single-quoted.<BR><BR>Alternatively use the ODBC cannonical format: {d &#039yyyy-mm-dd&#039} - eg:<BR><BR>MaidWorkPermitExpireDate = {d &#039 2001-01-01&#039}<BR><BR>The advantage of this format is that it&#039s understood by any ODBC-complient database and it&#039s always in the same format regardless of international settings.<BR><BR>Dunc

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts