This content has been marked as final. Show 2 replies
What Query expression are you trying to use for the Fiscal Year? LIKE '12/17/2012'. Why aren't you using the BETWEEN Operator or the Less than, Greater than Operator?
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?