AppGini Community Forums

Any tips on how to make this date show up as for example; 5-11-2020. It now shows as 2020-5-11. I did use the format command and got it to display as I wished, but then it stopped updating when it should have changed. Below is what I have now.

SELECT
DATE_ADD(`schedule`.`date_in`, INTERVAL `schedule`.`days` DAY)
FROM
`schedule`
WHERE
`schedule`.`sched_ID` = '%ID%'


Thank you,
David