Does any body know how I can convert Unix format dates ( no of seconds from 1/1/1970) to a date time format in Framework manager so I can use it in my reports?
This function will do the trick
cast(DATEADD({s}, [SOURCE].[tableName].[FieldName] , '19700101'), date)