# Dates with Kintone Calculated Fields

**URL:** <https://forum.kintone.dev/t/dates-with-kintone-calculated-fields/1555>\
**Category:** General\
**Tags:** calculated-field\
**Created:** [April 15, 2025, 6:29am UTC](https://forum.kintone.dev/t/dates-with-kintone-calculated-fields/1555 "2025-04-15T06:29:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![poonkodi](https://avatars.discourse-cdn.com/v4/letter/p/aeb1de/32.png) [@poonkodi](https://forum.kintone.dev/u/poonkodi)\
**Post date:** [April 15, 2025, 6:29am UTC](https://forum.kintone.dev/t/dates-with-kintone-calculated-fields/1555/1 "2025-04-15T06:29:04Z")

</div>

Kintone -Related to Calculated Field, as I found that calculated field with numbers working fine but calculated fields with dates **only for time differences** is not working as expected. Also, Filters are not working where calculated field contain date or hours

---

<div class="post-metadata">

**Author:** ![Chris](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.kintone.dev/chris/32/44_2.png) [@Chris](https://forum.kintone.dev/u/Chris)\
**Post date:** [April 15, 2025, 4:17pm UTC](https://forum.kintone.dev/t/dates-with-kintone-calculated-fields/1555/2 "2025-04-15T16:17:08Z")

</div>

Hello @poonkodi

It would be really helpful if you could share what you're working on, but when it comes to handling dates in calculations, it can be a bit tricky since you need to treat them as UNIX time. [Kintone has a helpful reference page on this](https://get.kintone.help/k/en/id/040502.html), so if you haven’t seen it yet, I recommend taking a look.

---

<div class="post-metadata">

**Author:** ![poonkodi](https://avatars.discourse-cdn.com/v4/letter/p/aeb1de/32.png) [@poonkodi](https://forum.kintone.dev/u/poonkodi)\
**Post date:** [April 15, 2025, 7:40pm UTC](https://forum.kintone.dev/t/dates-with-kintone-calculated-fields/1555/3 "2025-04-15T19:40:20Z")

</div>

Hello Chris, I am working on Records. Trying to retrieve records based on filters which has calculated field with date. Example created few records with calculated field with calculatedTime then in the Permissions for Records page, Add Permission Set with condition as CalculatedTime isequalto 7:30 . which is not working as expected.

 ![image](https://canada1.discourse-cdn.com/flex035/uploads/kintone/original/1X/62fcbb9e77c69dc9e4f1cb5b796dcb7690cee666.png)

---

<div class="post-metadata">

**Author:** ![Chris](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.kintone.dev/chris/32/44_2.png) [@Chris](https://forum.kintone.dev/u/Chris)\
**Post date:** [April 15, 2025, 8:31pm UTC](https://forum.kintone.dev/t/dates-with-kintone-calculated-fields/1555/4 "2025-04-15T20:31:41Z")

</div>

Hello @poonkodi

Thank you for sharing the details.

As mentioned in the help page I shared earlier, when working with date or date/time fields in Kintone, the values need to be in UNIX time—that is, in seconds. So for your example of 7:30, you would need to enter **27000** (which represents 7 hours and 30 minutes in seconds), rather than using the 7:30 format directly.

Could you give that a try and see if it works for you?