Date Formating

[msflinx]

I'm feeling really stupid right now. I have a text box in the group footer that is a date field. Where do I put this expression,

=format(fields!activitydate.Value, "dd-MMM-yy")

so that it affects my field?

I have tried these boxes in the Properties box:
1) Format field
2) Value box

The format field doesn't effect the preview of the field at all. The Value box makes the preview field display as the literal dd-MMM-yy.

Thank you

 

[msflinx]

Figured it out. My data was coming in as a string, not a date. Had to change the expression to:

=Format(cDate(Fields!activitydate.Value),"dd-MMM-yy")

in the value property and all is well.