Why does a listbox_item with a formula not sort correctly?

[datanibbler]

Hi,

I have a strange issue:

- I have a listbox coming from a database with a date-time-stamp.

- I use the following formula to extract the time - which does work. That's not the issue.

  >> TIME(Frac(num(TRAN_DATE)), 'hh:mm') <<

=> So I omit the seconds, but nobody cares about those.

The strange thing is, when I have a listbox_item with this formula and make a selection elsewhere, only one time is selectable there - that is okay - but the listbox doesn't sort.

I tried sorting it by "status - ascending" - that way the selectable one should be on top, yes?

Well, it isn't - nor at the bottom, either - it's somewhere in the middle. It is there all right - but why doesn't it sort?

Can someone give me a hint here?

Thanks a lot!

Best regards,

DataNibbler

P.S.: Ok, I have entered part of the formula in the corresp. field now - Frac(num(TRAN_DATE)) - and it works. But I still don't understand why?

[anbu1984 · Accepted solution]

Sorting the values in a listbox when using an expression in the sort tab

[datanibbler]

Thanks!

One doesn't really have to understand everything - it's quite enough to know how to avoid the situation 😉

I will try putting the same formula in my script.

Best regards,

DataNibbler