I have a date and time field I need to convert to true date time field.
This works but is not recognized at a datetime field with I apply other formulas to it for filtering, such as previous month data, etc...
atsdate + ' ' + atstime AS AtScene
returns this value:
Still a string, not datetime
I am using SQL 2005 and SSRS 2008r2
Thanks in advance