I need to develop one report where i need Year .
can i get only datepart for date field(attribute ) ?
ex.as in simple SQl statement ,
Select DATEPART( Year , getdate() ) It will give me current year .
Similarly i want to get year part for below FetchXML .
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="cms_mytable">
<attribute name="cms_mydate" />
</entity>
</fetch>
I don't need it in JavaScript or C#/VB script code. i mean i am trying it on FetchXML results only .
any help would be much appreciate.