If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Date (multiple) format in textbox
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 & " " &. |
#2
|
|||
|
|||
Date (multiple) format in textbox
I figured it out!
& " " & Format([StartDate],"mmmm dd\,yyyy") & " " & "to" & " " & Format([EndDate],"mmmm dd"", ""yyyy") & " " & "Prohock" wrote: 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 & " " &. |
Thread Tools | |
Display Modes | |
|
|