Date format 1373895087

hi all,

i have a field called submitted date which contains this data: 1373895087 which should correspond to: 2013-07-15 15:31.

In my dataset i want to use this field as a date field (something like 20130715) any ideas how to do this?

hope you can help me with this

thanks

M