EPICOR date field.... via BAQ calc field, eliminate TIME from output

[JoeVINKO83 (Joseph Jackiewicz)]

I have to believe there is a simple process/command to eliminate the TIME
Kinetic

ex: fiscal period end-date 01-31-2023 T00:00:00 desired result 01/31/2023
using CAST result 01/31/2023 12:00AM

Per google search, attempted other suggested methods

[NateS (Nate Schoonover)]

In your BAQ on the format line for the date/time field, change the format to short year date as in the screenshot.

Good luck!