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?

[nilesh_gangurde]

try tis.

Date(Floor( Date(DATE_FIELD)),'DD/MM/YYYY') as DATE

-Nilesh

[#3]

Try This

=Date(Yourdatefield,'DD.MM.YYYY')

or

your date field in text try like this

=date(num(date#(Yourdatefield,'DD.MM.YYYY')),'DD.MM.YYYY')

[#4]

Hi Nilesh,

Unfortunately that didn't work either...

[jonathandienst]

Hi

Date(Floor( Date#(DATE_FIELD)),'MM.DD.YYYY hh:mm') as DATE

or

Date(Floor( Date#(DATE_FIELD)),'M.D.YYYY hh:mm') as DATE

HTH

Jonathan

[#6]

  Use this:- It might help u

SubField (TimeStamp1,'  ', 1)

Thanks

D J

[rustyfishbones · Accepted solution]

try this

[#8]

Sorry, neither of those didn't work

[MK_QSL]

=Date(FLOOR(YourDateField),'DD.MM.YYYY')

[#10]

That works!!! Thanks for your help! I mean all of you!