Date (multiple) format in textbox

P

Prohock

I have a report that is a letter and it is displaying multiple dates.

I would like the dates to have the following format (mmmm dd", "yyyy). I
need to add this to the textbox rather than the format value for the record
source property.

The text box code is as follows & " " & [StartDate] & " " & "to" & " " &
[EndDate] & " " &.

I am thinking that it mightbe something like this...but it does not work.

& " " & [StartDate]=mmmm dd", "yyyy & " " & "to" & " " & [EndDate]=mmmm dd",
"yyyy & " " &.
 
P

Prohock

I figured it out!

& " " & Format([StartDate],"mmmm dd\,yyyy") & " " & "to" & " " &
Format([EndDate],"mmmm dd"", ""yyyy") & " " &
 

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

Code for format two dates to September, 21 - 23, 2009 1
Report from and to in header with a twist 3
UCase with Now() function 1
Report doesn't show all records between dates 11
Date format textbox? 2
Putting in the Date ranges on a report 3
I'm going bonkers here 2
Format Date with Text 1

Top