# JSONata - time picture construct not working?

**URL:** <https://discourse.nodered.org/t/jsonata-time-picture-construct-not-working/5981>\
**Category:** General\
**Created:** [20 December 2018 11:19 UTC](https://discourse.nodered.org/t/jsonata-time-picture-construct-not-working/5981 "2018-12-20T11:19:52Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![IoTPlay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/iotplay/32/40_2.png) [@IoTPlay](https://discourse.nodered.org/u/IoTPlay)\
**Post date:** [20 December 2018 11:19 UTC](https://discourse.nodered.org/t/jsonata-time-picture-construct-not-working/5981/1 "2018-12-20T11:19:52Z")

</div>

Hello to JSONata bofs,

This statement does **not** work:  
`$fromMillis(($.timestamp), '[D]/[M]/[Y]')`  
but this one does:  
`$fromMillis(($.timestamp)')`

Does this mean that the picture construct per [JSONata docs](https://docs.jsonata.org/date-time-functions#frommillis) was not implemented in Node-RED?

(re _timestamp_ field, I create that in a prior step, and is in JS timestamp format...)

---

<div class="post-metadata">

**Author:** ![Andrei](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/andrei/32/10446_2.png) [@Andrei](https://discourse.nodered.org/u/Andrei)\
**Post date:** [20 December 2018 12:28 UTC](https://discourse.nodered.org/t/jsonata-time-picture-construct-not-working/5981/2 "2018-12-20T12:28:48Z")

</div>

> [@IoTPlay](#):
>
> $fromMillis(($.timestamp), '[D]/[M]/[Y]')

I guess the reason is that Node-RED implements (at the time of this writing) JSONata version 1.5.4. The functionality you are trying to use is available on JSONata version 1.6.x

See the testing result in JSONata exerciser web page:

 ![r-01](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/7/73477903a7b747cdeeae83968bc76dbf69703e33.png)

 ![r-02](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/a/ac1a07591b762f6905dd31eb07ce1b5038280faf.png)

---

<div class="post-metadata">

**Author:** ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Post date:** [20 December 2018 12:45 UTC](https://discourse.nodered.org/t/jsonata-time-picture-construct-not-working/5981/3 "2018-12-20T12:45:59Z")

</div>

JSONata 1.6 was only published this week. We'll pick it up in Node-RED 0.20.

---

<div class="post-metadata">

**Author:** ![IoTPlay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/iotplay/32/40_2.png) [@IoTPlay](https://discourse.nodered.org/u/IoTPlay)\
**Post date:** [20 December 2018 13:18 UTC](https://discourse.nodered.org/t/jsonata-time-picture-construct-not-working/5981/4 "2018-12-20T13:18:45Z")

</div>

Thank you both !!