# \#equation-field **URL:** https://forums.knack.com/tag/equation-field/143.md [Latest](https://forums.knack.com/latest.md) · [Categories](https://forums.knack.com/categories.md) · [Tags](https://forums.knack.com/tags.md) --- ## [Calculating days between two dates](https://forums.knack.com/t/calculating-days-between-two-dates/8906)
**Author:** [@AndrewBang54366](https://forums.knack.com/u/AndrewBang54366)\ **Replies:** 4\ **Last updated:** [May 4, 2023, 4:38pm UTC](https://forums.knack.com/t/calculating-days-between-two-dates/8906 "2023-05-04T16:38:18Z")
I think Knack could use one more date function to calculate the number of days between two dates. Subtracting two dates doesn't quite work because the system uses both date and time for each field even if "ignore time" i… --- ## [Reference END DATE of a Date/Time Field Please!](https://forums.knack.com/t/reference-end-date-of-a-date-time-field-please/11999)
**Author:** [@RealEyesDisplays](https://forums.knack.com/u/RealEyesDisplays)\ **Replies:** 14\ **Last updated:** [November 7, 2022, 5:58am UTC](https://forums.knack.com/t/reference-end-date-of-a-date-time-field-please/11999 "2022-11-07T05:58:09Z")
Hello, Though there’s many improvements I’d love to see with the calendar, there’s ONE that will save the most about of time: Please please please allow us to reference the END DATE of a Date/Time field with filters, … --- ## [Running Sum](https://forums.knack.com/t/running-sum/9399)
**Author:** [@KeithSterl25609](https://forums.knack.com/u/KeithSterl25609)\ **Replies:** 4\ **Last updated:** [October 10, 2021, 11:11am UTC](https://forums.knack.com/t/running-sum/9399 "2021-10-10T11:11:52Z")
Would be nice to calculate a running sum. You can do it with a regular sum field on a connected object but this only works if the records are added in order, which isn't a true running sum. --- ## [Ability to use further connected data in equations field](https://forums.knack.com/t/ability-to-use-further-connected-data-in-equations-field/6426)
**Author:** [@Guilhermeb42087](https://forums.knack.com/u/Guilhermeb42087)\ **Replies:** 0\ **Last updated:** [April 23, 2019, 7:30pm UTC](https://forums.knack.com/t/ability-to-use-further-connected-data-in-equations-field/6426 "2019-04-23T19:30:00Z")
I would like to be able to use further connected objects (that seems to be available only for reports) in order to compose an equation field with other math and data elements. --- ## [Left and Right Padding string function](https://forums.knack.com/t/left-and-right-padding-string-function/6487)
**Author:** [@NicolasMor21396](https://forums.knack.com/u/NicolasMor21396)\ **Replies:** 0\ **Last updated:** [January 31, 2020, 10:52am UTC](https://forums.knack.com/t/left-and-right-padding-string-function/6487 "2020-01-31T10:52:00Z")
Basic but usefull function. Sample to pad left with zeros: PadLeft(\[field\], '0') Thanks! --- ## [Please add the ability to display calculations in Engineering or Scientific Notation](https://forums.knack.com/t/please-add-the-ability-to-display-calculations-in-engineering-or-scientific-notation/8923)
**Author:** [@SteveBalla15396](https://forums.knack.com/u/SteveBalla15396)\ **Replies:** 0\ **Last updated:** [May 11, 2020, 12:14pm UTC](https://forums.knack.com/t/please-add-the-ability-to-display-calculations-in-engineering-or-scientific-notation/8923 "2020-05-11T12:14:00Z")
Please add the ability to display calculations in Scientific and/or Engineering Notation. e.g. 0.0000197177 to have the option to be displayed as 1.97 x 10^-5 in scientific. If you were able, you could go as far as addi… --- ## [Chi-Square (χ2) Statistic](https://forums.knack.com/t/chi-square-2-statistic/8922)
**Author:** [@SteveBalla15396](https://forums.knack.com/u/SteveBalla15396)\ **Replies:** 0\ **Last updated:** [May 11, 2020, 11:48am UTC](https://forums.knack.com/t/chi-square-2-statistic/8922 "2020-05-11T11:48:00Z")
Please add Chi-square and Chisquare inverse function. --- ## [Table Summaries by column](https://forums.knack.com/t/table-summaries-by-column/6194)
**Author:** [@JoshuaHorw47792](https://forums.knack.com/u/JoshuaHorw47792)\ **Replies:** 1\ **Last updated:** [November 21, 2017, 12:02pm UTC](https://forums.knack.com/t/table-summaries-by-column/6194 "2017-11-21T12:02:02Z")
I would like to control what kind of summary a table does column by column. For example some columns I'd like a sum and some I'd like an average. Right now the best I can do is have the whole table do a sum and average, … --- ## [Advanced Function Fields](https://forums.knack.com/t/advanced-function-fields/10382)
**Author:** [@Brandon](https://forums.knack.com/u/Brandon)\ **Replies:** 29\ **Last updated:** [November 7, 2015, 11:56am UTC](https://forums.knack.com/t/advanced-function-fields/10382 "2015-11-07T11:56:40Z")
We're considering adding specialized field types for advanced functions and calculations. Things like "Square Root" for number fields and "Day of Month" for date fields. We'd love any suggestions for function types and …