Re: Simple use of substr problem

With stupiddate defined as a decimal 8.0 field:

With SQL:
with T1 as (
select substr(char(stupiddate),1,6) as yearmonth
from rob/htf)
select yearmonth, count(*) as nbrper
from t1
group by yearmonth
order by yearmonth

You could also do it this way in SQL:
select substr(char(stupiddate),1,6) as yearmonth,
count(*) as nbrper
from rob/htf
group by substr(char(stupiddate),1,6)
order by substr(char(stupiddate),1,6)

With Query/400
Define Result Fields
Field Expression
STUPIDCHAR digits(stupiddate)
YEARMONTH substr(stupidchar,1,6)
Select Sort Fields
Sort
Prty A/D Field Text
1 A YEARMONTH substr(stupidchar,1,6)
Select Report Summary Functions
---Options--- Field Text
5 YEARMONTH substr(stupidchar,1,6)
Define Report Breaks
Break Sort
Level Prty Field Text
1 10 YEARMONTH substr(stupidchar,1,6)




Rob Berendt