Thanks David, it's not working still so might need to revert to Code to get it to work

Evil Kraig F (2/3/2011)

---

How about just moving the date around to work within standard functionality?

Basically, take 3 months off an April date, for sorting purposes only, and make the system...

thanks Sarah

That seems to have sorted it

Luis Cazares (12/4/2014)

---

Yes, I made a mistake by not including the 2nd parameter of LEFT function. You should have been able to solve it by yourself.

=UCase(Left(Fields!Event_Type.Value,1)) & LCase(Right(Fields!Event_Type.Value, Len(Fields!Event_Type.Value)...

HD_JOHN (12/4/2014)

---

After talking with you briefly and understanding more this is what I came up with for anyone else that might need this.

Public Function FirstWordProper(ByVal word...

Sorry, with your solution...

Awesome, worked perfectly - sorry for taking so long to respond

Thanks to all who replied, neither scenario appears to work though 🙁

thanks, I'll give it a go

Van Heghe Eddy (10/3/2012)

---

shelts (9/28/2012)

---

Yes I know that but for each new report the date format reverts back to US with the month first. The easiest way around it...

Yes I know that but for each new report the date format reverts back to US with the month first. The easiest way around it I've found so far...

Carolyn Richardson (1/24/2008)

---

There is a simpler way, by default reporting services are installed using English (United States) as the default date format adjust the Report properties language to English (United...