Sorting Class() time Interval

[Anonymous]

Hello Everyone,

How can I sort this expression, I have seen thread for Numeric value but did not find anything for Time Interval..

=time(subfield(Class((T_SEG),(1/24/60)*$(VInput)),' ',1),'hh:mm')

& ' to '

& time(subfield(Class((T_SEG),(1/24/60)*$(VInput)),' ',5),'hh:mm')

Please suggest

[kkkumar82]

Hi,

I think you can use the autonumber() for the same expression and use it in the "Sort" tab.

Thanks

Kiran Kumar

[sunny_talwar]

May be use a dual() function around your current dimension and then use it with a number to do a numeric sort

[kkkumar82]

Hi ,

This may help you.

https://www.youtube.com/watch?v=X6d6K-pFX_8

Thanks

Kiran Kumar

[Anonymous]

Autonumber() is a script function not UI function

[Anonymous]

tried with dual() but no success

[sunny_talwar]

Do you have a sample you can share?

[marcus_sommer · Accepted solution]

This don't work?

=dual(

time(subfield(Class((T_SEG),(1/24/60)*$(VInput)),' ',1),'hh:mm')

& ' to '

& time(subfield(Class((T_SEG),(1/24/60)*$(VInput)),' ',5),'hh:mm'),

num(subfield(Class((T_SEG),(1/24/60)*$(VInput)),' ',1)))

- Marcus

[Anonymous]

Nope!!

See the attachment..

If I try in like Properties -> Sort -> Text -> A-Z, it works but with some selection it does not work, so I thought to go for expression to sort...

[Anonymous]

Shared.