Format dates inside text box with text

[wdrspens]

Hi,
I have an unbound text box into which I insert some text and a date, specifically:

="We will keep the date pencilled in until " & [DateEntered]+15 & ". If you would like a firm booking please, before that date, either pay the Discounted Amount or the Booking Deposit."

However the result is that [DateEntered]+15 includes the hours minutes and seconds, which I do not want. I just want the English format dd/mm/yy.
How do I format the [DatedEntered]+15 within the text box?
[DateEntered] is supposed to be formatted within the original table in the appropriate manner, but for some reason or other it changes within the above described text box.
With many thanks
David

 

[allan57]

use the Format command,
format([DateEntered]+15 , "dd/mm/yy")

 

[wdrspens]

Thank you Allan, you are a star. I was sure that it was something like your suggestion, but I could not work out the syntax. Brilliant, it works perfectly. Thank you.
David