Access default values to SQL Server 2008 RRS feed

  • Question

  • I am migrating an Access mdb that has several tables that contain datetime fields with a default value of DateAdd("d", 90, Date()) and also DatePart("y",DateAdd("y",-1 Date()))

    I know there may be some issues with these functions converting to Transact SQL functions. SSMA keeps telling that parameter 1 of DateAdd is wrong.

    Any help?

    Tuesday, November 9, 2010 8:26 PM