Forum Discussion
Change DateTime to Date in API setup
Hi all, I'm trying to build a semantic model that currently exists as an Excel Spreadsheet using a mixture of SQL Data pulled from some retail/booking software and some tabs that rely on manual d...
Hi BUC ,
Base on your description, it sounds like you are trying to change the DateTime field to a Date field in your API setup. And you will create relationship between sql table and this api table base on date type field. You can create a a calculated column as below to get it:
Column = FORMAT([DateTimeColumn], "MM/DD/YYYY")Best Regards