SSRS BAQ Report - Option Field Not Getting Converted to dd/MM/yyyy format

Kinetic ERP
10

Hi Kane… I have achieved this two ways… First one is just splitting the option field by date , month and year, I am getting the result in “dd/MM/yyyy” format.

=Mid(CStr(First(Fields!Option01.Value, “BAQReportParameter”)),4,2) & “/” &
LEFT(CStr(First(Fields!Option01.Value, “BAQReportParameter”)), 2) & “/” &
RIGHT(CStr(First(Fields!Option01.Value, “BAQReportParameter”)), 4)

Secondly in the data set expression query , I converted the option01 as convert(varchar(10),convert(datetime,[Option01]),103) as [Option01]

This too gives the result in dd/MM/yyyy format.

1 Like