Date format in text box with VB coding

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help,
I have a text box with this info, but I want both the Start and End date to
be formatted with the mmm,yyy format.
Can someone help me with this code please.

="Performance Information " & [Enter a User Name] & "
for the period between " & [Enter a Start Date] & " and " & [Enter an End
Date] &" Format ([Enter a Start Date],"mmm,yyyy")

Thank you.
Judy
 
Try

="Performance Information " & [Enter a User Name] &
" for the period between " &
Format([Enter a Start Date], "mmm,yyyy") &
" and " & Format ([Enter an End Date],"mmm,yyyy")

(all on one line, of course)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dlookup 3
Can't format a text box 5
Text to date format? 0
Ordering of Dates when formatted in a query 2
Date Format in a Text Box 2
Form filter & macro 4
Excel How to change the "Short Date" format in Excel? 4
Date range for a query 4

Back
Top