if you´d use ADDT´s datepicker, you wouldn´t need to worry about that :-)
honestly, if a column like "expirationDate" is supposed to store the year-month-day value in a mysql compatible format, I can´t think of any reason to not use the datepicker.
However it´s possible to apply stuff like that to a certain transaction value before it´s getting submitted to a table -- here´s a str_replace example which would replace a forward slash (/) with a hyphen:
My example was just a for instance. I have a cc expires column that already contains data like 01/08. I just started playing around with str_replace() to try and attach the function to an insert or update record for that column and couldn't figure out how to do it.
But as usual, you've come through in a flash! Thanks for the help.