Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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')))
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'))
Hi, It didn't work, but thanks for your posting.
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')))