|
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.
|
