max date issue

[Anonymous]

Hi,

I am trying to get max datetime value form QVD.

But it is giving blank in text object. In database the value is like below. Can anyone suggest on this issue

In qlikview

Regards,

Kumar

[Chanty4u]

try this

Timestamp(max(DateField),'YYYY-MM-DD hh:mm:ss')

[Chanty4u]

i think your date field coming as text.

add your date field in listbox and send screen shot.

[Anonymous]

Thanks for your reply. I tried with that formula but it is not working.

Regards,

Kumar

[Chanty4u]

it is coming as text .  thats why it  is showing " -"

[Anonymous]

I tried with below value

=max(timestamp(timestamp#(Record_Updated_Datetime,'DD/MM/YYYY hh:mm:ss'))).

But it is giving me PM at end of the value like . I want to exclude PM in that result

[Anonymous]

I don't understand how are you saying that it is text value. Can you tell me.

[Chanty4u]

try this

=max(timestamp(Record_Updated_Datetime,'DD/MM/YYYY hh:mm:ss'))

[Anonymous]

I tried with that already.

[Anonymous · Accepted solution]

I got  solution using below expresssion.

=purgechar(max(timestamp(timestamp#(Record_Updated_Datetime,'DD/MM/YYYY hh:mm:ss'))),'AMP')