Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
FetchXML to specific a specific date, in this fiscal year RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    I am trying to create an advanced find for opportunities based that were created on or after April 1st, last year OR on or before March 31st, this year.

    Essentially, I need the year portion to update dynamically while the specific month reference stays the same. I already have to do manipulations to the FetchXML and am wondering if there is a way to write that statement.

    Thank you :)

    Friday, May 12, 2017 7:28 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    Have you tried to use "Fiscal Year" filters against your created on field? Something like following:

    Dynamics CRM/Business Solutions MVP
    Read My blog

    Friday, May 12, 2017 8:28 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Thank you for your response. I do have other views using Fiscal Year, however our Fiscal Year is July 1st - June 30th. Your response does make me curious if another "[name] year" could be created and designated as April 1st to March 31st. I will look into that, thanks.

    Monday, May 15, 2017 11:41 AM