Long Date in Report

[mdg]

I have a report that I want a long date placed within the control source such as " " & [Date1] but it only displays the short date 6/7/11 instead. Is there a way to display the long date in a report when you place the date field inside the control source location with other expressions.
THank you.

 

[spikepl]

use the Format function to display the date as desired

 

[mdg]

I tired that before and it still only displays the short date. My Control source entry is as follows ="text"&[DateField] &"text" . The long date displays in my query and will display in my report if the control source is just DateField - without the text part, but then switches to the short date display when I add the text etc into the control source area. Thanks

 

[spikepl]

Lookup the function FORMAT in the docs. And I do not mean the property of a field

 

[mdg]

Thanks
spikepl
I used the Format function in front of the field name and placed the long date items in the order I wanted. Thank You. It took a bit to figure it out but, now I know how!!!

 

[spikepl]

I hope you enjoyed the experience, visit us again soon