9 Oct
2003
9 Oct
'03
6:15 a.m.
Dear All, I am facing problems while converting American date format(MM/DD/YYYY) to MySQL date format(YYYY/MM/DD). Here I'm giving the code I'm using, please suggest where I have gone wrong and how to rectify. test_front: <dtml-var la_header> <form name="data" ACTION="test_back" METHOD="POST"> <input type="text" name="date2" size="15" value=""> <input type=submit name=submit value=update> </form> test_back: <dtml-if "submit=='update'"> <dtml-if "date2==_.None"> <dtml-var date2 null=""> <dtml-else> <dtml-call "REQUEST.set('date2',date2.strftime('%Y/%m/%d'))"> <dtml-var date2 null=""> </dtml-if> </dtml-if> <dtml-var date2> -- Thanks & Regards Praveen Kumar SoftPro Systems Ltd