Cannot Coerce value into type class.java.date

[drewdin]

I have a date in mysql, i have a query that pulls the date onto the screen to be displayed. The date in the database "2023-02-03 10:10:10" gets displayed in epoch time when queried "121234124144124124"

When i try to run a transform or expression to convert the epoch to a date i get the error in the title. I can script something to fix it but i figured I could do this out of the box.

Anyone have any suggestions? Thanks

[justinedwards.jle]

I'm not familiar with maker edition, but I remember encountering a similar problem in Perspective a little while back, and this was the solution:

Two Tables Question Using Text Fields

you need to add a mapping to those three text fields to map their values to a datetime Here i added a custom property called valueIn (that’s where you’d be writing your value to instead of the text property) Then add a binding on text to this.custom.valueIn and finally a Format Transform setup with whichever datetime format you want to display [image]

[drewdin]

Thanks, I just ended up using a scalar query and it worked fine with a format binding. The issue was that it was returning a dataset. thanks though