I have a row formula in a cross tab that contains this code :
CStr({@hour1},0) + ':00'
@hour1 is : hour({LABSTORE.REC_TIME})
What I get is a column like this
10 : 00
11 : 00
12 : 00
.
.
.
9 : 00
How can I sort this properly like it were a number?
I mean like this
9 : 00
10 : 00
11 : 00
12 : 00
Thank you.
CStr({@hour1},0) + ':00'
@hour1 is : hour({LABSTORE.REC_TIME})
What I get is a column like this
10 : 00
11 : 00
12 : 00
.
.
.
9 : 00
How can I sort this properly like it were a number?
I mean like this
9 : 00
10 : 00
11 : 00
12 : 00
Thank you.