How to filter datetimes only by month/year

Posts   
 
    
rodri
User
Posts: 8
Joined: 23-Apr-2007
# Posted on: 30-Sep-2007 21:45:11   

hello,

I need to obtain a set of data filtered by date, but only by month and year (I don't want to know the day) I mean applying a mask.

For example: I'd like to fetch all rows where my startDate and endDate are inside 2007/January, the hole month

Is this possible?

thanks a lot

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 30-Sep-2007 23:20:36   

Hi rodri, if you are using LLBLGenPro v2.x you can use _DBFunctionCall _to access _YEAR _and _MONTH _DB functions. http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=9720

David Elizondo | LLBLGen Support Team