'in-year' operator in FetchXml condition

Question

I was looking for an 'in-year' operator in FetchXML conditions, but only found the 'in-fiscal-year' operator.

Is there a workaround for this functionality?

Answer 1

The only Condition Operators defined by the Schema for years that are not fiscal operations are:

• last-year
• this-year
• next-year
• last-x-years
• next-x-years

If you want a specific year (in 2008 for example) your best bet is to use the between operator:

<condition attribute = 'createdon' operator='between'>
    <value>2008-01-01 00:00:00</value>
    <value>2008-12-31 23:59:59</value>
</condition>