locked
Advanced Find - "This Week" clause RRS feed

  • Question

  • When in Advanced Find you have the option to filter data based on different time intervals (this week, this month, this year etc..)

    In terms of "This Week"   Will this filter for all data on Sunday 12am or after for the current week?  Just want to confirm, thanks!

    Monday, August 27, 2012 2:35 PM

Answers

  • Hi,

    The first day of the week for a CRM Organization is configurable. It should be 12 AM on the day you set as the first day of the week. The time calculcation will also be affected by the logged in CRM user's time zone.

     

    Regards,

     

    Mayank

    • Proposed as answer by MayankAgrawal Monday, August 27, 2012 6:10 PM
    • Marked as answer by AvePoint_James Thursday, August 30, 2012 3:16 PM
    Monday, August 27, 2012 6:10 PM

All replies

  • It goes by your CRM organization week settings. In regional settings, you define what the start of the week is.
    Monday, August 27, 2012 6:01 PM
    Moderator
  • Hi,

    The first day of the week for a CRM Organization is configurable. It should be 12 AM on the day you set as the first day of the week. The time calculcation will also be affected by the logged in CRM user's time zone.

     

    Regards,

     

    Mayank

    • Proposed as answer by MayankAgrawal Monday, August 27, 2012 6:10 PM
    • Marked as answer by AvePoint_James Thursday, August 30, 2012 3:16 PM
    Monday, August 27, 2012 6:10 PM
  • Thanks to both of you!
    Thursday, August 30, 2012 3:21 PM
  • For anyone interested in digging deeper into how the date and time operators are applied in Advanced Find queries and views, I recommend reading this great article from Gonzalo Ruiz: http://gonzaloruizcrm.blogspot.com/2012/07/date-and-time-operators-in-crm-explained.html

    Not all of these are very obvious to the user. For example, Next Week vs. Next 1 Weeks is a different query criteria.


    Jukka Niiranen - My blog: Surviving CRM - Follow @jukkan on Twitter

    Thursday, August 30, 2012 5:52 PM