How to get a first possible value form list box

[#1]

Hi all,

I want to get first value of possible value form list box.

For Ex:

Here I have a two possible value(2:45:44 AM and 2:45:46 AM)

And I want to get Value 2:45:44 AM.

Could u please help me.

Thanks in advance.

Regards,

Kabilan K.

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

You can either use the Min() function or the FirstSortedValue() function. In this case, I think that the Min() function will be enough, as you want to get the earliest time in the day:

TimeStamp(Min(StartTime))

Hope that helps.

Miguel

[Anonymous]

Hi Kabilan,

Use peek function, If I have understood your problem correctly.

Peek('Timefield', 0, 'table'));

Or refer peek function from help menu.

Thanks,

Skumar

[#4]

Hi Miguel,

Thank You,

Regards,

Kabilan K.

[#5]

Hi  Skumar,

I think, We can use the peek() function in Edit script dialog box.

And we can't use it in a Edit expression dialog box.

If, I am wrong Please let me know.

Regards,

Kabilan K.

[Anonymous]

Hi Kabilan,

You are right, peek() function is script function, hence can't be used in expression in UI.

Best Regards,

Skumar