Using NOW() date function

[PRodgers4284]

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:

Application.Dialogs(xlDialogSendMail).Show "MyName@MyCompany.domain", fieldone & " " & fieldtwo & " " & Now() & " Name of workbook", True

[dominicb]

Good afternoon PRodgers4284

How about :

Application.Dialogs(xlDialogSendMail).Show "MyName@MyCompany.domain", fieldone & " " & fieldtwo & " " & Format(Now(), "dd/mm/yy") & " Name of workbook", True

HTH

DominicB

[DonkeyOte]

Worth adding perhaps that in VBA you have

Date, Time, Now

[sweep]

or

Application.Dialogs(xlDialogSendMail).Show "MyName@MyCompany.domain", fieldone & " " & fieldtwo & " " & Day(Now()) & "/" & Month(Now()) & "/" & Year(Now()) & " Name of workbook", True

[PRodgers4284]

Good afternoon PRodgers4284

How about :

Application.Dialogs(xlDialogSendMail).Show "MyName@MyCompany.domain", fieldone & " " & fieldtwo & " " & Format(Now(), "dd/mm/yy") & " Name of workbook", True

HTH

DominicB

Many thanks dominicb, that worked well

[ron2k_1]

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:

Application.Dialogs(xlDialogSendMail).Show "MyName@MyCompany.domain", fieldone & " " & fieldtwo & " " & TEXT(NOW(),"dd/mm/yy") & " Name of workbook", True