Converting Timestamp in Date

[george55]

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.

[Taoufiq_Zarra]

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

[andoryuu]

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

[george55]

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

[george55 · Accepted solution]

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