Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005

    Unanswered: SQL Server/Excel Date discrepancy

    Here's a strange one - anyone else come across this :

    In SQL2K
    select cast(cast ('08-dec-2005' as datetime ) as int) returns 38692

    In Excel2002 SP3
    Put the same date in a cell and format it as a number and you get 38694

    Presumably the products have a different start date

  2. #2
    Join Date
    Jan 2005
    Green Bay
    Ran accross the same problem with a third party application a while back.

    The issue also is apparent in Access.

    THe vender had created a process to delete based upon numerical representation of the date. Caused all kind of issues.

Posting Permissions

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