Gabe Lebron
asked on
Current Month Filter in Visual Studio
ASKER
This did not work, i am looking to filter on current month. So grab todays date and give me everything from that month.
So grab todays date and give me everything from that month.That's a simple SELECT in SQL Server:
SELECT *
FROM TableName
WHERE MONTH(DateColumn) = MONTH(GETDATE())
Can you transpose this for your VS object?
ASKER
So if I go back to the dataset and filter it there. its using a firebird odbc connection so I cant find the syntx.
SELECT SOITEM.ID, SOITEM.PRODUCTID, SOITEM.SOID, SOITEM.TYPEID, SOITEM.STATUSID, SO.STATUSID AS Expr1, SOITEM.UOMID, SOITEM.SOLINEITEM,
SOITEM.DESCRIPTION, SOITEM.PRODUCTNUM, SOITEM.CUSTOMERPARTNUM, SOITEM.TAXABLEFLAG, SOITEM.TAXID, SOITEM.TAXRATE, SOITEM.QTYTOFULFILL,
SOITEM.QTYFULFILLED, SOITEM.QTYPICKED, SOITEM.UNITPRICE, SOITEM.TOTALPRICE, SOITEM.DATELASTFULFILLMENT, SOITEM.REVLEVEL,
SOITEM.EXCHANGESOLINEITEM, SOITEM.ADJUSTAMOUNT, SOITEM.ADJUSTPERCENTAGE, SOITEM.QBCLASSID, SOITEM.DATESCHEDULEDFULFILLMENT,
SOITEM.DATESCHEDULEDFULFILLMENT AS Expr2, SOITEM.NOTE, SOITEM.TOTALCOST, SOITEM.SHOWITEMFLAG, SOITEM.ITEMADJUSTID,
SOITEM.DATELASTMODIFIED, SOITEM.MCTOTALPRICE, SOITEM.MARKUPCOST
FROM SO SO, SOITEM SOITEM
WHERE (SOITEM.STATUSID <> 50) AND (SOITEM.STATUSID <> 60) AND (SOITEM.STATUSID <> 70) AND (SO.ID = SOITEM.SOID) AND (SO.STATUSID <> 10) AND
(SOITEM.DATESCHEDULEDFULFILLMENT = "MONTH"(GETDATE()))
ORDER BY SOITEM.TOTALPRICE
Get rid of the double quotes around MOUNTH and the table field also should have the MONTH function applied:
(MONTH(SOITEM.DATESCHEDULE DFULFILLME NT)= MONTH(GETDATE()))
ASKER
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
that seemed to work!! thanks... if i wanted only the next month would i do Current_Date + 1))
ASKER
go it this worked
(EXTRACT(MONTH FROM SOITEM.DATESCHEDULEDFULFIL LMENT) = EXTRACT(MONTH FROM CURRENT_DATE)+1)
(EXTRACT(MONTH FROM SOITEM.DATESCHEDULEDFULFIL
ASKER
Sweet!
DATEADD(m, X, DATEDIFF(m,0,CURRENT_TIMES
The value of X is missing. See the example below for X ( monthsValue).
' Add the months to the date example.
Dim newDate As Date = DateAdd(DateInterval.Month