hussain husain
| December 24, 2012 at 12:54 am you made weird mistakes there
first the type is varchar not date “which is not very bad”
second you use 2 type of dates at the same time “Nov 21, 2012” and “21-11-2012” so its nearly impossible to make me able to make payment report for accountant : |
Josh
| December 24, 2012 at 8:36 am Hi Hussain, I’m sorry for the trouble. It may help to explain the the payment date format in the events_attendee table will use the date format that is set in the WordPress>General Settings option page. So if your accountant requires a year/month/day format, you can change it to the corresponding setting: screenshot You can even set custom formats by using this guide:
http://codex.wordpress.org/Formatting_Date_and_Time Please note that if you change this now, it will only affect payment records going forward, it will not change payment records already stored in the database. |
