Formatting a date in a text box

  • Thread starter Thread starter Steve Welman
  • Start date Start date
S

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
 
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")
 
Back
Top