Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
this query is for the data of the current month and year this works nYear = current year 2011 nMonth = current month 3 sql.Format("SELECT * FROM ViewLieferscheine WHERE \ DATEPART(year,Lieferscheindatum)=%d AND\ DATEPART(month,Lieferscheindatum)=%d \ ORDER BY CAST(LieferscheinNr AS BIGINT)DESC ",nYear,nMonth);
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.