I'm trying send a personalize SMS and with help in another posts here I constructed this AMPScript:

%[ VAR @mobile, @date SET @mobile = MOBILE_NUMBER SET @date = FORMAT(Lookup('DE_NAME','DATE_FIELD','MobilePhone',@mobile),"dd/MM/yyyy") ]%% Pay you bill at %%=v(@date)=%%,or contact us.

However when I have two contacts using the same phone number both SMS shows the same date.

There is another way to get what I need?

I'm trying send a personalize SMS and with help in another posts here I constructed this AMPScript:

%[ 

VAR @mobile, @date 
SET @mobile = MOBILE_NUMBER 
SET @date = FORMAT(Lookup('DE_NAME','DATE_FIELD','MobilePhone',@mobile),"dd/MM/yyyy")

]%%
Pay you bill at %%=v(@date)=%%,or contact us.

However when I have two contacts using the same phone number both SMS shows the same date.

There is another way to get what I need?