Currently I am pulling the date and time from a JSON object and it is returning the date and time in UTC(according to their API there is no way to change that time-zone). I would like the timestamp to be in UTC+2, I do not mind creating more columns to achieve this. Is there any way to do this throu…

Also correct me if I am wrong but in my second post I showed a date format in which my values then became this and yet it still doesn’t work in the math column? [Screenshot 2023-10-31 092014]

[image] MattGlides: I have done this however it is not returning a value? (I also tried the original Javascript colum) The Text to Date column expects an ISO8601 string by default (which is what you have), so you don’t need to provide any Format parameters. If you just pass your original date…

I copied exactly what you did however it is still returning it as a ISO string [Screenshot 2023-10-31 114510] [Screenshot 2023-10-31 114521]

Yes, if you click into the cell it will appear like that. But did you try passing it into a math column?

Yes thank you it did work, one last question a bit out of topic but the license plate text is in ISOstring too, also pulling using Javascript. How would I convert it into a text so that I can show it in my app layout?

Can you show me what it looks like?

[Screenshot 2023-10-31 121140] Sure, here we go

So if you try and use that in a Text type component it doesn’t work? I would expect that it should. And actually it does work for me. [CleanShot 2023-10-31 at 18.24.22] Only difference I think is that I used a Query JSON column instead of JavaScript. But I shouldn’t expect that to make any diffe…

Sorry I should have been more specific, so the point is for it to be a text entry field. That way if the plate recognizer does not show up with a number plate, they can enter a unique pin. If it does show up in our data then it automatically puts it into the text field. The text entry field does not…

I’m not sure I follow. Do you mean you want to use it as a default value for a Text Input? That should be possible, depending on context. But you certainly can’t use it as the target of Text Input. And no amount of transformation will help with that, as you cannot write to computed columns.

Converting date and time in data table from UTC to UTC+2

Ask for Help

ThinhDinh November 1, 2023, 11:53pm 25

Topic		Replies	Views
How is data stored by Glide? Ask for Help date-math	9	398	July 16, 2023
How to convert a text column into a real date that Glide recognizes as date column? Ask for Help	9	121	July 27, 2026
Input Format for Text to Date computed column to output the correct time Ask for Help date-math , tutorial , computed-columns	7	99	September 24, 2025
Convert Date and Time to Zulu Ask for Help	34	2471	May 31, 2022
How can I make Glide read a date as a string? Ask for Help date-math	21	839	November 8, 2023

Converting date and time in data table from UTC to UTC+2

Related topics