Hi Chaim, Just convert the date to a number and then back to a date. SELECT (DATE(1950,1,1) + ROUND(AVG(datetest -DATE(1950,1,1)),0)) FROM Samples
>Sorry, not resolvd. >
select samples.datetest,SYS(11,datetest)as sss where not empty(datetest) from samples into cursor testy nofilter >select distinct datetest from testy where sss in (select avg(sss) from testy)