Formatting a date in a text box

[Steve Welman]

Hi

I have a text box on my form and in the text box I want to display the
message "Persal letters sent on 6 January 2006"

Now to do this I am entering

="Persal letters sent on " & now()

Which displays Persal letters sent on 06/01/2006 08:28:31

I basically need to know how to supress the display of the time by
formatting the now()

Thanks in advance

Steve

 

[Allen Browne]

Use the Format() function to specify how you want the date to look, e.g.:
="Persal letters sent on " & Format(Date(), "d mmmm yyyy")
or perhaps:
="Persal letters sent on " & Format(Date(), "Long Date")