Post reply

update a date field / off of 90 day

  • May 11, 2007 at 1:44 pm

    #116799

    duh !!

    MY MISTAKE - it not a calulated field thet date is an offsit depending on the type of record. it was my state that was wrong here the correction and it works. granted hard coding a date is bad form, but I needed to test the correction out

    declare @Newdate datetime

    SET @Newdate = '6/16/2007'

    UPDATE [TRACKIT7_DATA2].[dbo].[TASKS]

    SET [DUEDATE] ='6/16/2007'

     FROM [TRACKIT7_DATA2].[dbo].[TASKS]

    where RESPONS = person one' and STATUS = 'Overdue'

     

  • May 11, 2007 at 1:55 pm

    #705983

    First, your UPDATE syntax is incorrect.  Second, if DUEDATE is a calculated field, it can't be updated, the fields that make up the calculated field needs to be updated.  If you could post the DDL for the table and some sample data, I'm sure you will get some help.  If not from me, some one else will step, that's just how we all work!

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply