How to convert timestamp to date format

[#1]

Hi all,

I have problem with timestamp format dates. Below you'll see some examples.

• 1.1.2013 08:00
• 10.1.2014 14:30
• 31.12.2013 21:30
• 1.11.2013 01:15

What I need is a date (DD.MM.YYYY).

I've tested so far almost everything I can find from here. Nothing works. Any good ideas?

[materi]

Thanks Nilesh! That helped me too.