When connecting external connections that bring back data from views or stored procedures - the data comes back as text (varchar) even though the data in Xano or (SQL Server). Kyle has confirmed that this is intentional on Adalo's part but having data come back as text forces you to format data (as money, date, long date, etc) BEFORE it reaches Adalo and you are not able to define display properties of numbers or dates - since the data type is text.