[Zope] formatting a date string

[Graham Chiu]

I'm trying to convert a string from

2000/12/31 
( which is the format a date string is returned by a sql query )

to 

31-DEC-2000

which is the format I need to enter date values into the database.

I figured I need to index into 'JANFEBMARAPR.... '

Now m_date is '2000/12/31', so I need to convert the 12 to an integer.

but <dtml-call "REQUEST.set('month',_.string.atoi(m_date[5:7],10))">

gives me a null value for month.

-------
Regards,        Graham Chiu
gchiu<at>compkarori.co.nz
http://www.compkarori.com/dynamo - The Homebuilt Dynamo
http://www.compkarori.com/dbase - The dBase bulletin