Report View sorting DateTime column

Question

How can I sort data in ReportView by column containing datetime

In rdlc file I have placed Table where I have in 1 column in Details =Fields!StartTime and in Header I set Interactive Sort with sort expression : =Fields!StartTime

in 2 column I check if the field contains date =IsDate(Fields!StartTime)

When I execute it second column contains all true but it still don't sort properly.

Answer 1

function IsDate recognize Fields!StartTime as date but it still sorts it as string changing sorting expression to =CDate(Fields!StartTime) worked