Long date

[samotek]

I have the following control in my report:
="Payment :" & "" & [required date]
I have placed the format to long date but nevertheless i get the result with a short date. How can i format it to long date?

 

[xwordmark]

Based on what you've shown, the control on the report is not returning a date, it is returning a string, and the date is a part of that string. So you need to format the date before putting it in the string. How about:

="Payment :" & "" & CStr(Format([required date],"mmmm d, yyyy"))

 

[SkipVought]

Hi,

The Format function returns a STRING, so ther's no need to use the CStr function...

"Payment :" & "" & Format([required date],"mmmm d, yyyy")
[/codw]


Skip,
[sub]
[glasses]Just traded in my old subtlety...
[b]for a NUANCE![/b][tongue][/sub]

 

[dhookom]

I'm not sure why you use the extra double quotes. Don't forget the first "="

 ="Payment: " & Format([required date],"mmmm d, yyyy")

Duane
Hook'D on Access
MS Access MVP