Changing date from 2016-01-22 to 01-22-2016
I've seen posts that are similiar but not quite my same issue. My data is coming in like 01/22/2016 and DOMO is changing it to 2016-01-22. Can you please help on converting it to month-day-year format.
I've used the below but wondering if there is anything in the ETL(Magic preferrably) to do it so I don't have to have multiple beastmodes for date all over my selects.
DATE_FORMAT(`Start/Invoice Date`, '%m-%d-%Y')