Hi,

I'm fairly new in the world of Webfocus , and i have the following problem :

I have a database field date of birth and i want to do an across on it by year , is there anyway to do this ?

the field has a standard date format but i want to across on the YY format

Peter

Peter-
Yes there is a way to do this in WebFOCUS.
Extract the year portion of the standard date into a what FOCUS terms a virtual field. In this instance a DEFINE is suggested.
DEFINE MYFILE
ACROSSYY/YY = DOB;
END
TABLE FILE MYFILE
PRINT STUFF
ACROSS ACROSSYY
BY SOMEOTHER
END
This should get you started.

Thanks Jim !!

I played with your solution a bit , and when i tried

HNAME(DOB 'YEAR', 'A4') in define , it works !!

Thanks for enabling me to sleep tonight

Peter