Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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
Hi Miguel,
Thank You,
Regards,
Kabilan K.
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.
Hi Kabilan,
You are right, peek() function is script function, hence can't be used in expression in UI.
Best Regards,
Skumar