# How is current week determined for Select?

**URL:** <https://community.spicecrm.io/t/how-is-current-week-determined-for-select/367>\
**Category:** KReporter\
**Created:** [October 24, 2018, 8:50pm UTC](https://community.spicecrm.io/t/how-is-current-week-determined-for-select/367 "2018-10-24T20:50:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![tessupport](https://avatars.discourse-cdn.com/v4/letter/t/b2d939/32.png) [@tessupport](https://community.spicecrm.io/u/tessupport)\
**Post date:** [October 24, 2018, 8:50pm UTC](https://community.spicecrm.io/t/how-is-current-week-determined-for-select/367/1 "2018-10-24T20:50:04Z")

</div>

We would like to run reports for Saturday at 12a to following Friday at 12:59p. Current Week filter seems to only pull from Monday - Sunday.

Is there a way to change Current Date so we don’t have to edit a between filter everytime the report is run?

---

<div class="post-metadata">

**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\
**Post date:** [October 25, 2018, 6:09am UTC](https://community.spicecrm.io/t/how-is-current-week-determined-for-select/367/2 "2018-10-25T06:09:37Z")

</div>

Possible operators for date fields cannot achieve what you would like to have. You can only select from a specific date to another one or within n days (weeks or months).  
With specific dates you would have to change the report each week.  
With n days you would not get the week days as you.  
Creating a custom function for function operator might help. Right now I don’t remember how it exactly works. But I think you might be able to pass where clause parameters this way.

---

<div class="post-metadata">

**Author:** ![rsp](https://avatars.discourse-cdn.com/v4/letter/r/4491bb/32.png) [@rsp](https://community.spicecrm.io/u/rsp)\
**Post date:** [January 8, 2025, 2:12pm UTC](https://community.spicecrm.io/t/how-is-current-week-determined-for-select/367/3 "2025-01-08T14:12:47Z")

</div>

@maretval Hello, how _ **current week** _ works? I have _current week_ as filter, but it is displaying data from the 1st & 2nd week of January.

Does it consider Monday to Sunday as week?

---

<div class="post-metadata">

**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\
**Post date:** [August 18, 2025, 6:18am UTC](https://community.spicecrm.io/t/how-is-current-week-determined-for-select/367/4 "2025-08-18T06:18:50Z")

</div>

I checked the logic and yes, it is meant for Monday to Sunday as a week.  
I sent a change request to the team (CR1002055)