problem with timestamp to get max value

[Anonymous]

Hi,

I have timestamp column and trying to get max value from this function. But it is displaying null value

=MaxString(Date(Floor(Timestamp#(account_created_datetime)),'DD/MM/YYYY')).

Plese help me on this

Regards,

Kumar

[#2]

Max(Date(Floor(Timestamp#(account_created_datetime, 'TimeStampFieldFormatHere')),'DD/MM/YYYY'))

[sunny_talwar]

Because your date is 11/06/2015 09:40:56.000000

those extra 0s at the end either needs to be removed using SubField() function (SubField(FieldName, '.', 1) means take everything before the dot)

or you can use what Stefan prescribed:

Max(Date(Floor(Timestamp#(account_created_datetime,'DD/MM/YYYY hh:mm:ss.fff')),'DD/MM/YYYY'))

here the extra 0s are taken care by .fff