> I create the shape dynamically at thhe end of along prg run. The tooltip code works fine until I try to add the date.

Could You for a test just try to use

DTOC(date())

instead of

Transform(DMY(thenextdate))

?