You could add a date to the table and specify a unique index on the specific fields including todays date.
CREATE TABLE [dbo].[Clients] (
client_id int ,
first_name string NOT NULL,
last_name string NOT NULL
created_on date NOT NULL
CONSTRAINT clients_unique UNIQUE ([first_name], [last_name], [created_on])
) ON [PRIMARY]
This way it becomes impossible to add a second client with the same first and last name on a certain date.
Good luck!