"Change Hours" writes wrong time in database

[boston85719]

this can help

Anyone know how to convert :formatted as text result to date?

Using the formatted as text operator will turn any data type into a text type and only display the values rather than create the values in the same data type. So when you have date fields in your yes/no sections for the format as text, both are being turned into a text object. But what you are doing is completely possible, just needs the proper setup and tools. First here is a quick look at the setup and result [Screen Shot 2021-09-03 at 12.34.17 PM] [Screen Shot 2021-09-03 at 12.34.11 PM] …