# Converting date and time in data table from UTC to UTC+2
**URL:** https://community.glideapps.com/t/converting-date-and-time-in-data-table-from-utc-to-utc-2/67377
**Category:** Ask for Help
**Created:** [October 30, 2023, 10:49am UTC](https://community.glideapps.com/t/converting-date-and-time-in-data-table-from-utc-to-utc-2/67377 "2023-10-30T10:49:27Z")
**Posts on this page:** 5
**Page:** 2
### Author:  [@MattGlides](https://community.glideapps.com/u/MattGlides)
#### Post date: [October 31, 2023, 1:42pm UTC](https://community.glideapps.com/t/converting-date-and-time-in-data-table-from-utc-to-utc-2/67377/21 "2023-10-31T13:42:10Z")
> [@Darren\_Murphy](#):
>
> You’d need to prepare a mutation for each row, bundle that up into a JSON payload, and use a Call API action to send the payload.
I understand the words, however I do not understand the theory behind it. Tomorrow or if you have time tonight, do you mind doing an example? I know its a lot but it would really help, or ofc if you can find a link(I’ve tried on YT and Glide Community)
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [October 31, 2023, 1:46pm UTC](https://community.glideapps.com/t/converting-date-and-time-in-data-table-from-utc-to-utc-2/67377/22 "2023-10-31T13:46:49Z")
Here is a video that I made a few months ago. It should give you the general idea.
---
### Author:  [@MattGlides](https://community.glideapps.com/u/MattGlides)
#### Post date: [November 1, 2023, 11:43am UTC](https://community.glideapps.com/t/converting-date-and-time-in-data-table-from-utc-to-utc-2/67377/23 "2023-11-01T11:43:45Z")
Hi Darren, I have tried trial and error for getting this to work based on my understanding of your video however I cannot. Let’s assume an API is returning a JSON object of a license registration. We use Javascript(or query JSON) to pull the two values we want from the object, such as plate number and timestamp. We now want to use the Call API action to put those values into basic columns, such as text. How would I go about this?
---
### Author:  [@MattGlides](https://community.glideapps.com/u/MattGlides)
#### Post date: [November 1, 2023, 2:27pm UTC](https://community.glideapps.com/t/converting-date-and-time-in-data-table-from-utc-to-utc-2/67377/24 "2023-11-01T14:27:08Z")
> [@Auto-populating fields in Glide](https://community.glideapps.com/t/auto-populating-fields-in-glide/67445):
>
> The basis is that after they process the photo, it automatically gets sent to an API who returns the plate number as a JSON object, then we convert that to standard text using Glide’s API (See first image). The problem I am running into is that I want the numPlateManual in the layout page (See image 2) to auto-populate with the plate number that we pull. I thought converting it to text would make this possible however now it just shows the very first number in the column no matter what. Is it po…
This is what I am struggling with now
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [November 1, 2023, 11:53pm UTC](https://community.glideapps.com/t/converting-date-and-time-in-data-table-from-utc-to-utc-2/67377/25 "2023-11-01T23:53:18Z")
> [@Auto-populating fields in Glide](https://community.glideapps.com/t/auto-populating-fields-in-glide/67445/2):
>
> I assume you must have a flow somewhere that sets the plate number column to txtPlateNumber. This would allow the number to be manually edited after the API automation. That doesn’t sound right. On which screen and at what point of the flow are you using the text entry component?
[Previous page](https://community.glideapps.com/t/converting-date-and-time-in-data-table-from-utc-to-utc-2/67377.md?page=1)