Hi,

I have a Date field on a SQL database stored as varchar. I want to call a report and select data for the current month but have to convert the text to date first. This is the code line I'm using :

orpt.DataDefinition.RecordSelectionFormula = "{Month(convert(varchar(20), cast([Transaction Details].TDate as datetime), 103))} = " & dt.Month

I keep on getting errors and I am not too sure if Im on the right track. Please assist