Using NOW() date function

I need some help formatting the NOW() function to display the current date as dd/mm/yy, at present it displays the date and time, i dont want the time included. Im using the code below to email a worksheet and i want the current date to be in the title:

Please Login or Register  to view this content.

Originally Posted by dominicb

Good afternoon PRodgers4284

How about :

Please Login or Register  to view this content.

HTH

DominicB

Many thanks dominicb, that worked well

Well you said that you want your date format to be dd/mm/yy; you will notice that if you use sweep's suggestions it will give you September as "9" instead of "09" and 2009 instead of "09", if you really want the date format as you want it (dd/mm/yy).

So you we can use sweep's concept and use this formula:

Please Login or Register  to view this content.