SSRS find max of converted date field

datevalue function is not in SSRS

I think what you need is this

FORMAT(MIN(CDate(Fields!DDMMYYYY.Value)),"dd/MM/yyy")

---

Please Mark This As Answer if it solved your issue

Please Mark This As Helpful if it helps to solve your issue

Visakh

----------------------------

My MSDN Page

My Personal Blog

My Facebook Page

Hi Thanks for the suggestion I tried this but is still comes back as a error stating that conversion from string to type date is not valid