Only Max Values

[Anonymous]

Hi,

I am attaching the sample app .refer it and  provide the solution.

Hope some one would help me out this.

Thanks in advance

[Gysbert_Wassenaar]

Try this expression: only({<StartDate={'$(=date(max(StartDate)))'}>}StartDate)

[#3]

Hi,

try this

only({<StartDate={'$((=date(only(max(StartDate))))'}>}StartDate)

[Anonymous]

Thanks for responding me

Could you try with this date in Excel file.

the same expression is not working with the date

[Gysbert_Wassenaar]

Works for me.

[Anonymous]

Could you share me the sample app

I will look into probably I missed out something

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[Anonymous]

Gysbert,

Coould you also check this please?

seeking your suggestion

[Gysbert_Wassenaar]

Since you're working with timestamps instead of plain dates you'll have to make sure to format the result as a timestamp too: only({<Start={'$(=timestamp(max(Start)))'}>}Start)

[Anonymous]

HI Thanks for valuable solution but still I need the max time stamp to be converted in Dates

I need the Max dates in the output though it is timestamp fields