Date (multiple) format in textbox

  • Thread starter Thread starter Prohock
  • Start date Start date
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 & " " &.
 
I figured it out!

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