Hi all

Well no it's not my birthday It's only to introduce the very-simple-but-annoying problem I've got I've an table with a birtdate (ie : 16/11/1979) And I want to display all anniversary (? birtday ) between 2 dates

For example want all birthday between 10/11/2004 and 20/11/200 and it'll select me 16/11/1979.

The query I have is (Sql Server) :

 SELECT     E_ID, E_NAME, E_FIRSTNAME, E_BIRTHDATE
FROM    EMPLOYEE
WHERE 
DATEPART(dayofyear, E_BIRTHDATE)  
    BETWEEN DATEPART(dayofyear, '2004-11-10')
    AND DATEPART(dayofyear, '2004-11-20')

My problem is that I don't know how to put it in llblgen Any help is welcome !

ty Fab

This is currently not possible... (executing parameter requireing functions on fields) (so a stored procedure is sadly the only option..

Ok I'll d that ty