How do I set Date & Time to a Thing?

gianlucamb9 · 2024-09-05T23:18:06.051Z

I am using the Date/Time Picker to set a Date AND Time to a thing and then display it in a table.

Screenshot 2024-09-05 at 5.15.14 PM822×546 28.3 KB

The date is saved just fine but no matter what time I set, it always gets saved as 00:00.

Screenshot 2024-09-05 at 5.15.26 PM1234×1412 65.8 KB

Here’s how my Workflow looks like:

Screenshot 2024-09-05 at 5.13.51 PM932×1188 76 KB

I have found that if I check the auto-binding option it saves correctly, but if I use a button to make changes to the thing, it doesn’t work.

What am I doing wrong?

ntabs · 2024-09-06T00:47:50.180Z

Not sure if I’m missing out on something obvious here but the workflow seems to be fine. Have you checked the DB if the values are saved properly? If they are, then it’s probably how you’re displaying the data or a privacy rule issue

gianlucamb9 · 2024-09-06T00:54:57.264Z

DB is saving the date and time in a very weird manner. I thought it had something to do with timezone but my default setting is to use my current timezone.

I save a date and time, say 19:15. And in the DB it is saved as 12:30. It doesn’t make sense.

Screenshot 2024-09-05 at 6.54.45 PM356×664 7.19 KB

ntabs · 2024-09-06T01:03:13.125Z

Do you have any timezone overrides?

gianlucamb9 · 2024-09-06T01:04:42.450Z

No overrides.

gianlucamb9 · 2024-09-06T01:12:18.043Z

@ntabs Hey I fixed the issue. I simply deleted the Date/Time Picker component and added another one. I think it was buggy. It is saving and displaying date and time correctly now.

Thank you!