Hi all, can someone kindly point me to a resource that converts all kinds of possible date inputs into MySQL format of YYYY-MM-DD? example of formats to be converted includes: d/m/yy d/m/yyyy d/mm/yy d/mm/yyy dd/mm/yy dd/mm/yyy d/mmm/yy d/mmm/yyyy dd/mmm/yy dd/mmm/yyyy yy - 2 digit representation of year yyyy - ful numeric representation of year m - numeric representation of month, without leading zero mm - numeric representation of month, with leading zero mmm - short textual representation of month d - day of month without leading zero dd - day of month with leadin zero thanx! hwee