Max date problem

[#1]

Hi All,

I have a date timestamp field, called "Creation Timestamp.History" , which I'd like to get the Max per Order Number.

I've used the expression : max([Creation Timestamp.History]), BUT it returns no values.

It should return : 03/08/2012 12:46:31 , in my attached example.

I'm not sure if it's just an issue with Timestamps, but I'm definitely doing something wrong?

Any tips?

Cheers!

[#2]

Creation Timestamp.History is not in date format, its in character format

first create the date by using left, right and makedate function.... then it will work

[#3 · Accepted solution]

Hi,

    Please use the below Expression in the Chart .

max(Timestamp( Timestamp#([Creation Timestamp.History] , 'DD/MM/YYYY hh:mm:ss' ) ,'DD/MM/YYYY hh:mm:ss'  ))

Regards

Yusuf

[#4]

try this

max(date([Creation Timestamp.History],'DD/MM/YYYY hh:mm:ss'))

[#5]

Thank you all for your feedback