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
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, so if you haven’t seen it yet, I recommend taking a look.
1 Like
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.
1 Like
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?
1 Like