Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to convert timestamp to date format

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?

1 Solution

Accepted Solutions
10 Replies
nilesh_gangurde
Partner - Specialist
Partner - Specialist

try tis.

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

-Nilesh

Not applicable
Author

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')

Not applicable
Author

Hi Nilesh,

Unfortunately that didn't work either...

jonathandienst
Partner - Champion III
Partner - Champion III

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


Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

  Use this:- It might help u

SubField (TimeStamp1,'  ', 1)

Thanks

D J

rustyfishbones
Master II
Master II

try this

2014-01-29_1122.png

Not applicable
Author

Sorry, neither of those didn't work

MK_QSL
MVP
MVP

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

Not applicable
Author

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