I’m using this event on BeforeInsert
/**
- Adding one month(30days) to the due date
*/
//Initializing the parameters to be add
$add_days = 0; //adding 30 days
$add_months = 0; //adding nothing to months
$add_years = 1; //adding nothing to years
{next_due_date} = sc_date({test_date}, ‘yyyy-mm-dd’, ‘+’, $add_days, $add_months, $add_years);
It’s going in the database as yyyy-mm-dd just like my test_date field, but when it’s viewed in my editable grid it’s 11/02/2017 instead of 11-02-2017. test_date shows 11-02-2016 like it should. How can I fix this or is this a bug.
UPDATE: Edit - this can be closed. After looking and looking I see that for the field you also have to use regional settings or not and display a separator.