Unix format dates

[Veekaygee]

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?

[istein]

This function will do the trick

cast(DATEADD({s}, [SOURCE].[tableName].[FieldName] , '19700101'), date)