In my table MemberMaster, my goal is to change the DAY in the DateJoined date to 01 if the current DAY = 15, run as a SQL Command statement. The original data excluded a DAY (only had month and year from an XL file). I forced DAY=15, but changing to 01 will solve several testing issues for reporting. I have tried the following code, but apparently I’m way off the mark, as I get a schema error on t1.
Any help will be appreciated.
Thanks in advance, Joe
UPDATE "MemberMaster"SET "DateJoined" = (SELECT "t1"."DateJoined" ( DateAdd( 'dd', - 14, "t1"."DateJoined") )FROM "MemberMaster" AS "t1"WHERE "t1".MemberID"="MemberMaster"."MemberID"AND (DAY, "t1"."DateJoined" ) =15