How do I trim the Time off a date value In-DB with a snowflake data source

[CKeyFur]

Currently the field is showing values like '2021-09-03 17:03:34' and I would like to remove the time at the end just to have the YYYY-MM-DD

[atcodedog05]

Hi @CKeyFur 

Use select tool and change datatype to date.

Hope this helps : )

[CKeyFur]

So a coworker showed me how to do what I was trying for this odd task. It was in the formula Tool and putting the Output field to whatever you want it and change type to date then SQL Expression of:
CAST("CALLTIME" AS DATE)