# Simple painless date different calculated field **URL:** \ **Category:** Kibana\ **Created:** [December 2, 2017, 5:02am UTC](https://discuss.elastic.co/t/simple-painless-date-different-calculated-field/109999 "2017-12-02T05:02:31Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![BrianBeaulieu](https://avatars.discourse-cdn.com/v4/letter/b/8797f3/32.png) [@BrianBeaulieu](https://discuss.elastic.co/u/BrianBeaulieu)\ **Post date:** [December 2, 2017, 5:02am UTC](https://discuss.elastic.co/t/simple-painless-date-different-calculated-field/109999/1 "2017-12-02T05:02:31Z")
Should something like this work? `doc['timestamp'].value - doc['data.LOGON_TIME'].value;` I've tried numerous variations. Setting variables. using a return statement. I basically just need to know how many milliseconds or seconds between these 2 fields. I get this message in Discover: Courier Fetch: 5 of 25 shards failed. ---
**Author:** ![weltenwort](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/weltenwort/32/53885_2.png) [@weltenwort](https://discuss.elastic.co/u/weltenwort)\ **Post date:** [December 5, 2017, 12:36pm UTC](https://discuss.elastic.co/t/simple-painless-date-different-calculated-field/109999/2 "2017-12-05T12:36:48Z")
Hi @BrianBeaulieu, you should be able to access the millisecond values as `long`s using `doc['timestamp'].value.millis` and `doc['data.LOGON_TIME'].value.millis` respectively. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [January 2, 2018, 12:37pm UTC](https://discuss.elastic.co/t/simple-painless-date-different-calculated-field/109999/3 "2018-01-02T12:37:12Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.