# Latest **URL:** https://community.spicecrm.io/latest.md [Latest](https://community.spicecrm.io/latest.md) · [Categories](https://community.spicecrm.io/categories.md) --- ## [Welcome to SpiceCRM](https://community.spicecrm.io/t/welcome-to-spicecrm/8)
**Author:** [@system](https://community.spicecrm.io/u/system)\ **Replies:** 0\ **Last updated:** [November 16, 2016, 3:04pm UTC](https://community.spicecrm.io/t/welcome-to-spicecrm/8 "2016-11-16T15:04:49Z")
Welcome to the SpiceCRM Community Page! --- ## [CustomFunction on the Date field](https://community.spicecrm.io/t/customfunction-on-the-date-field/798)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 1\ **Last updated:** [August 5, 2026, 7:16pm UTC](https://community.spicecrm.io/t/customfunction-on-the-date-field/798 "2026-08-05T19:16:23Z")
Only Year DATE\_FORMAT({t}.{f}, '%Y') → Returns a 4-digit year (e.g., 2026). DATE\_FORMAT({t}.{f}, '%y') → Returns a 2-digit year (e.g., 26). YEAR({t}.{f}) → A direct alternative function to extract the year as a numeric … --- ## [CustomFunction to get Min](https://community.spicecrm.io/t/customfunction-to-get-min/797)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 0\ **Last updated:** [June 24, 2026, 4:36pm UTC](https://community.spicecrm.io/t/customfunction-to-get-min/797 "2026-06-24T16:36:50Z")
If we want to get the MIN for field. Could we use the below in the customFunction column? MIN({t}.{f}) Or MIN({f}.FIELDNAME) --- ## [Number of days between datetime and date fields](https://community.spicecrm.io/t/number-of-days-between-datetime-and-date-fields/796)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 0\ **Last updated:** [June 1, 2026, 4:10pm UTC](https://community.spicecrm.io/t/number-of-days-between-datetime-and-date-fields/796 "2026-06-01T16:10:04Z")
If you have one datetime and another date field. DATEDIFF(DATE({tc}.quote\_relDATETIMEase\_date\_c), {tc}.DATE) OR DATEDIFF(CAST({tc}.DATETIME AS DATE), {tc}.DATE) --- ## [How to extract year & month from date](https://community.spicecrm.io/t/how-to-extract-year-month-from-date/716)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 11\ **Last updated:** [May 29, 2026, 3:37pm UTC](https://community.spicecrm.io/t/how-to-extract-year-month-from-date/716 "2026-05-29T15:37:13Z")
Hello, I have date field like 05/18/2018 09:12AM or 2023-10-03 18:11:08. I want to display only year out of it. I am using the below Formula on the manipulate screen. But it is not working. substr(0,4) substr(5,2) … --- ## [How to add the 365 days to date field](https://community.spicecrm.io/t/how-to-add-the-365-days-to-date-field/795)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 0\ **Last updated:** [May 29, 2026, 3:36pm UTC](https://community.spicecrm.io/t/how-to-add-the-365-days-to-date-field/795 "2026-05-29T15:36:03Z")
We could use the below customFunction for date field. DATE\_ADD({t}.{f}, INTERVAL 365 DAY) --- ## [Calculate number of days in the KReport](https://community.spicecrm.io/t/calculate-number-of-days-in-the-kreport/794)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 1\ **Last updated:** [May 27, 2026, 1:51pm UTC](https://community.spicecrm.io/t/calculate-number-of-days-in-the-kreport/794 "2026-05-27T13:51:27Z")
Hello @maretval We want to calculate the number of days and display them in the columns of the KReport. We have Created Date and Modified Date fields in the record, and we want to know how many days have passed since t… --- ## [Display Full Name](https://community.spicecrm.io/t/display-full-name/790)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 3\ **Last updated:** [March 9, 2026, 1:37pm UTC](https://community.spicecrm.io/t/display-full-name/790 "2026-03-09T13:37:35Z")
Hello, We have first name and last name of user, and it is store as FN & LN in the kreport. Now, we want to add new column which will display the FN LN in the output table. How to do it? Solution: In the formula col… --- ## [installation error - Core Configuration](https://community.spicecrm.io/t/installation-error-core-configuration/778)
**Author:** [@wery](https://community.spicecrm.io/u/wery)\ **Replies:** 10\ **Last updated:** [March 6, 2026, 8:43pm UTC](https://community.spicecrm.io/t/installation-error-core-configuration/778 "2026-03-06T20:43:24Z")
I installed SpiceCRM according to the instructions https://www.spicecrm.com/wp-content/uploads/2024/12/SpiceCRM-Installation-Guide\_202402001.pdf at step: Go to the package loader and load the Essentials \> CORE package … --- ## [Truncating time off of Date Created field for Report](https://community.spicecrm.io/t/truncating-time-off-of-date-created-field-for-report/348)
**Author:** [@tessupport](https://community.spicecrm.io/u/tessupport)\ **Replies:** 2\ **Last updated:** [February 11, 2026, 10:18pm UTC](https://community.spicecrm.io/t/truncating-time-off-of-date-created-field-for-report/348 "2026-02-11T22:18:47Z")
Trying to create a report of contacts added last 7 days, grouped by day. Our Date Created field has a time stamp as well, so we get individual returns per time stamp, unless there was a dump of contacts at the same time… --- ## [Hmmm… can't reach this page](https://community.spicecrm.io/t/hmmm-cant-reach-this-page/789)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 1\ **Last updated:** [December 23, 2025, 7:48pm UTC](https://community.spicecrm.io/t/hmmm-cant-reach-this-page/789 "2025-12-23T19:48:57Z")
www.spicecrm.com --- ## [Presentation drilldown](https://community.spicecrm.io/t/presentation-drilldown/788)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 1\ **Last updated:** [December 3, 2025, 3:24pm UTC](https://community.spicecrm.io/t/presentation-drilldown/788 "2025-12-03T15:24:20Z")
We want to use presentation drilldown to get better understanding of the data. How to use it? What all report plugin supports it (standard view, group view)? --- ## [How to apply amount difference condition](https://community.spicecrm.io/t/how-to-apply-amount-difference-condition/786)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 1\ **Last updated:** [December 2, 2025, 9:21am UTC](https://community.spicecrm.io/t/how-to-apply-amount-difference-condition/786 "2025-12-02T09:21:05Z")
@maretval How can we use amount difference condition in the report. For example, we have amount1 and amount 2. We want to display records where amount1 \< amount2. --- ## [How to filter negative records](https://community.spicecrm.io/t/how-to-filter-negative-records/787)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 1\ **Last updated:** [December 2, 2025, 9:18am UTC](https://community.spicecrm.io/t/how-to-filter-negative-records/787 "2025-12-02T09:18:23Z")
We have added custom row in kreport called Final Amount. We are doing field1 - field2 to calculate amount for Final Amount column. Now, we want to display only -negative values in the table. How to do it? --- ## [How to find date difference between datetime and date field](https://community.spicecrm.io/t/how-to-find-date-difference-between-datetime-and-date-field/785)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 2\ **Last updated:** [November 3, 2025, 4:26pm UTC](https://community.spicecrm.io/t/how-to-find-date-difference-between-datetime-and-date-field/785 "2025-11-03T16:26:53Z")
Is it possible to calculate the date different between datetime and date fields using below CustomFunction? @maretval datediff({tc}.DateTime,{tc}.Date) --- ## [How to get year or month from field?](https://community.spicecrm.io/t/how-to-get-year-or-month-from-field/784)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 4\ **Last updated:** [November 3, 2025, 4:24pm UTC](https://community.spicecrm.io/t/how-to-get-year-or-month-from-field/784 "2025-11-03T16:24:50Z")
@maretval how to get the year or month out of date time field in the kreport. For example, the date field has value 10/20/2030 11:11pm. In the formula, column we tried to use the below but did not work. substr({Store… --- ## [Hide enum options by division rule](https://community.spicecrm.io/t/hide-enum-options-by-division-rule/783)
**Author:** [@gabs](https://community.spicecrm.io/u/gabs)\ **Replies:** 1\ **Last updated:** [October 14, 2025, 3:03pm UTC](https://community.spicecrm.io/t/hide-enum-options-by-division-rule/783 "2025-10-14T15:03:25Z")
Hello everyone, how are you? Is it possible to hide some enum options from a domain when I select a division inside the CRM? For example, if I select Division AUS, the options Agent and Competitor should be hidden. Is i… --- ## [Dropdown list not showing up after domain and dictionary setup](https://community.spicecrm.io/t/dropdown-list-not-showing-up-after-domain-and-dictionary-setup/782)
**Author:** [@gabs](https://community.spicecrm.io/u/gabs)\ **Replies:** 3\ **Last updated:** [September 19, 2025, 1:42pm UTC](https://community.spicecrm.io/t/dropdown-list-not-showing-up-after-domain-and-dictionary-setup/782 "2025-09-19T13:42:07Z")
Hello everyone, how are you doing? Could someone give me a hand? I’m trying to create a dropdown list. I created a new domain, set up the list, and added it to the dictionary. But even so, when I select the field, the l… --- ## [Override the name](https://community.spicecrm.io/t/override-the-name/780)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 3\ **Last updated:** [August 20, 2025, 9:02am UTC](https://community.spicecrm.io/t/override-the-name/780 "2025-08-20T09:02:40Z")
We have a kreport with the text field, it could have three values A,B & C. In visualize, we have Bar Chart & it is displaying the A, B & C as legend values & on the x-axis instead of that we want to display Apple, Banana… --- ## [How is current week determined for Select?](https://community.spicecrm.io/t/how-is-current-week-determined-for-select/367)
**Author:** [@tessupport](https://community.spicecrm.io/u/tessupport)\ **Replies:** 3\ **Last updated:** [August 18, 2025, 6:18am UTC](https://community.spicecrm.io/t/how-is-current-week-determined-for-select/367 "2025-08-18T06:18:50Z")
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 filt… --- ## [Calculate number of days](https://community.spicecrm.io/t/calculate-number-of-days/776)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 1\ **Last updated:** [August 18, 2025, 6:11am UTC](https://community.spicecrm.io/t/calculate-number-of-days/776 "2025-08-18T06:11:20Z")
Hello @maretval, :smiley: We have date created(mm/dd/yyy hh:mm AM/PM) and Completed Date (mm/dd/yyyy) formats in the Cases module. Now, we want to find the number of days between date created & completed date. How coul… --- ## [How to use Context and Reference?](https://community.spicecrm.io/t/how-to-use-context-and-reference/769)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 5\ **Last updated:** [August 18, 2025, 6:04am UTC](https://community.spicecrm.io/t/how-to-use-context-and-reference/769 "2025-08-18T06:04:04Z")
Hello @maretval, We want to use the Context and Reference fields in the kreport. But we do not know how to use them. Our requirement is that we want to display week value equal to zero when we do not have any reporting… --- ## [Merge two columns name in the chart legend](https://community.spicecrm.io/t/merge-two-columns-name-in-the-chart-legend/777)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 1\ **Last updated:** [August 15, 2025, 2:28pm UTC](https://community.spicecrm.io/t/merge-two-columns-name-in-the-chart-legend/777 "2025-08-15T14:28:30Z")
Hello @maretval, We have kreport with the column chart & it has the legends in the side. We want to add new filed in report by using Formula (For example, {field1}.-.{field2}). The field1 are all numbers, but field2 h… --- ## [KReports 4.4 on SuiteCRM](https://community.spicecrm.io/t/kreports-4-4-on-suitecrm/768)
**Author:** [@ijdavie](https://community.spicecrm.io/u/ijdavie)\ **Replies:** 3\ **Last updated:** [June 20, 2025, 1:38pm UTC](https://community.spicecrm.io/t/kreports-4-4-on-suitecrm/768 "2025-06-20T13:38:20Z")
Hello, I am experencing some really odd pagination when I add more than one KReport to the dashboard on SuiteCRM.When we click next to get the next page of results it will jump page 2 and display page 3, this happens ea… --- ## [Ability to Mass Update or Bulk Update from selected records](https://community.spicecrm.io/t/ability-to-mass-update-or-bulk-update-from-selected-records/765)
**Author:** [@processflow](https://community.spicecrm.io/u/processflow)\ **Replies:** 3\ **Last updated:** [March 26, 2025, 6:43pm UTC](https://community.spicecrm.io/t/ability-to-mass-update-or-bulk-update-from-selected-records/765 "2025-03-26T18:43:50Z")
Ability to Mass Update or Bulk Update from selected records Hello SpiceCRM, User Story The user has a series of Leads where the ‘Status’ needs to be updated - the user would like to Select the leads in question, and t… --- ## [Scheduled Reports fail if report has zero results](https://community.spicecrm.io/t/scheduled-reports-fail-if-report-has-zero-results/763)
**Author:** [@processflow](https://community.spicecrm.io/u/processflow)\ **Replies:** 3\ **Last updated:** [March 7, 2025, 5:34pm UTC](https://community.spicecrm.io/t/scheduled-reports-fail-if-report-has-zero-results/763 "2025-03-07T17:34:30Z")
Scheduled Reports fail if report has zero results it is expected that a report with zero results is still a report outcome and should be delivered via the schedule report function in Kreporter via email The ‘Scheduler … --- ## [General Inquiry re: User Group Management & record-level acl](https://community.spicecrm.io/t/general-inquiry-re-user-group-management-record-level-acl/762)
**Author:** [@processflow](https://community.spicecrm.io/u/processflow)\ **Replies:** 4\ **Last updated:** [March 7, 2025, 4:45pm UTC](https://community.spicecrm.io/t/general-inquiry-re-user-group-management-record-level-acl/762 "2025-03-07T16:45:57Z")
We are working on getting our heads around the method of applying ACLs to an ORG Unit. We would like to add an Org Unit to an ACL Profile – then when adding a User to the Org Unit, they should have the related ACL Pro… --- ## [Cannot install spicecrm](https://community.spicecrm.io/t/cannot-install-spicecrm/754)
**Author:** [@rsp](https://community.spicecrm.io/u/rsp)\ **Replies:** 6\ **Last updated:** [March 7, 2025, 4:23pm UTC](https://community.spicecrm.io/t/cannot-install-spicecrm/754 "2025-03-07T16:23:10Z")
I am trying to install spicecrm but it is stuck as loading screen. I could see 404 errors in console too. --- ## [Google Chrome Extension not loading in sidebar](https://community.spicecrm.io/t/google-chrome-extension-not-loading-in-sidebar/752)
**Author:** [@processflow](https://community.spicecrm.io/u/processflow)\ **Replies:** 2\ **Last updated:** [December 13, 2024, 2:18pm UTC](https://community.spicecrm.io/t/google-chrome-extension-not-loading-in-sidebar/752 "2024-12-13T14:18:55Z")
Google Chrome Extension not loading in sidebar running SpiceCRM version: 2024.01.001.1719212892250 I downloaded the plugin from my instance The Extension ZIP file is generated at https://yourcrm.frontend.url/config/gsu… --- ## [SpiceCRM installation comes back to "Set Backend Screen"](https://community.spicecrm.io/t/spicecrm-installation-comes-back-to-set-backend-screen/759)
**Author:** [@kpatil](https://community.spicecrm.io/u/kpatil)\ **Replies:** 3\ **Last updated:** [December 13, 2024, 1:51pm UTC](https://community.spicecrm.io/t/spicecrm-installation-comes-back-to-set-backend-screen/759 "2024-12-13T13:51:42Z")
Hello, When i try to install spicecrm on ubuntu 24.04 with apache 2.4.58 version, It loops back to the initial “Set Backend” screen after the “Review and Install” Screen. On the chrome debugger, there is a 503 for the “… [Next page](https://community.spicecrm.io/latest.md?page=1)