Update Trigger not using date in where clause causing all records with same key id to be updated instead of just the ones with the current date

I modified the where clause so that d.fldLastPhysical uses today’s date which resolved the issue. Apparently, there is something going on with i.fldLastPhysical cause my initial issue.

Thanks for the feed back Marc.