Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need some help with the clock in my application..
The problem is that hour 00:00 is sorted before hour 01:00 and not after 23:00..
value 5 in 01.04-00:00 supposed to be placed right in my table. After 01.04-23:00. How can i fix this?
Hello, Marius!
You can catch a midnight with Text() function:
=if(right(Text(time),8)='00:00:00',max(RowNo()),RowNo())
(This expression I used as sort expression.)
PFA.
but why?
what is 01:00 counting here? data from 00:00 to 01:00 or 01:00 to 02:00?
if 00:00 is 24:00, then just replace them with and IF() during load !!
Thanks, but it did not work.. now it shows 01.04 00:00, 02.04 00:00, 03.04:00 .....
any other suggestions?
/Marius
thanks for reply.
01:00 is 01:00 - 02:00
00:00 is 00:00/24:00 - 01:00
"if 00:00 is 24:00, then just replace them with and IF() during load !!"
got an example for that?