Issue with Min Time Fraction for the Max Date

[rustyfishbones]

Hi All,

I have the following Expression (It say Expression is OK, but it's not)

What I need is the Minimum Start Time for the Maximum Date

The expression works fine until I add the max date part

{<Date = {"$(=MAX(Date))"}>} (This works fine for other expression where I want to sum values for the max date)

Any idea what I could be doing wrong here

[alexandros17]

Try

Date = {"$(=Date(MAX(Date)))"}

[rustyfishbones]

Hi,

My Date is formatted correctly as it is working in other expressions

could it be I can't do this while using the TIME or FRAC part?

[rustyfishbones · Accepted solution]

Hi All,

I got this working with the following expression

Regards

Alan

[MK_QSL]

=TIME(Min({1}{<Date = {'$(=Date(Max(Date)))'}>}StartTime),'hh:mm:ss')

[rustyfishbones]

Thanks Manish that also works