Report Viewer Date Format..

Hi,

I have done a report using the reportviewer page, and placed it in my web application and the last thing i need to do is sort out the date formats, primarily to a UK time..

1. I want to display todays date on the page, but in the format "Wednesday, 4 April 2007". I seem to be able to get the various parts needed, but not put them together in the same textbox, could someone help me with the concatonation?

=WeekdayName(Weekday(DateValue(DateString)))

2. All the dates extracted from the database are in the format MM/dd/yyyy, and i need them to be in dd/MM/yyyy, i am completely lost on how to do this...

any help will be much appreciated, even if you could tell me where i can go look up the syntax for this markup

regards

Chris

check this for all posible date formats:http://msdn2.microsoft.com/en-us/library/8kb3ddd4.aspx

|||

cheers for the link, don't know why i was having such a hard time finding it..

anyway, all sorted now, in the end i didn't do any sort of concatenation, but instead just used =FormatDateTime(Now(), 1)

and the other days were as easy as putting dd/MM/yyyy HH:mm in the fomrat field, nice

cheers!

sql