Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
george54
Creator III
Creator III

Converting Timestamp in Date

Hi all,

Do have a Field (FIELD2) and it looks like this: "23.01.2020 - 08:04"

Could not convert it to a normal Date. My function looks like this:

Date(RangeMax(Max(FIELD1), Date(Floor(Timestamp#(Max(FIELD2), 'DD.MM.YYYY - hh:mm')), 'DD.MM.YYYY'))))

The Num( )Output is 43853.3365625. So I guess it is still a Timestamp.

Thank you for your help.

Labels (1)
1 Solution

Accepted Solutions
george54
Creator III
Creator III
Author

Hi Andoryuu

Thanks for the trick with "text". The solution war very closed, had to change position Floor & Date.

It works like this:

Date(Floor(Date#(Text(Max(PE_MUTATIONSDATUM)), 'DD.MM.YYYY - hh:mm')))

View solution in original post

4 Replies
Taoufiq_Zarra
Master II
Master II

I don't completely get it, but you can use

=Date(Date#(left(RangeMax(Max(FIELD1), Date(Floor(Timestamp#(Max(FIELD2), 'DD.MM.YYYY - hh:mm')), 'DD.MM.YYYY')),10),'DD.MM.YYYY'))

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
andoryuu
Creator III
Creator III

The following gives me an integer return using the now() timestamp function as a POC. You should be able to adapt this to your need:
=floor(date(date#(text(max(now())),'d/m/yyyy hh:mm:ss tt')))
george54
Creator III
Creator III
Author

Hi, It didn't work, but thanks for your posting.

george54
Creator III
Creator III
Author

Hi Andoryuu

Thanks for the trick with "text". The solution war very closed, had to change position Floor & Date.

It works like this:

Date(Floor(Date#(Text(Max(PE_MUTATIONSDATUM)), 'DD.MM.YYYY - hh:mm')))

View solution in original post