This content has been marked as final. Show 2 replies
Thanks Royston for yr reply.
My requirement is i need to fetch rcords of current year .
I need to count the number of quotations raised for that year.
But in DB i have date field(dquotationdate) but not year field.so for this datefield i need to compare only the year with current year
select * from quotationtable where year(dquotationdate) = datetime.now.year
I need my qyery exp to be like this.
Im stucked here badly.
Could someone help?