I don't use dtml ... But the cookbook I mailed in my previous post has this syntax: <li> strftime(%Y/%m/%d) --> <dtml-var expr="e.strftime('%Y/%m/%d')"></li><br> I would say you are missing expr="" so your code should probably look like <small><dtml-var expr="LG_DATA.strftime('%Y-%m-%d')"></small> I use zpt and my code is way different it looks like: <td tal:content="python:rowdata.datetime.strftime('%d/%m/%Y %X')">datetime</td> I don't know that I can be of much more help unfortunately. ____________________________________________ Peter Millar -----Original Message----- From: zope-bounces+peter.millar=parasyn.com.au@zope.org [mailto:zope-bounces+peter.millar=parasyn.com.au@zope.org] On Behalf Of Zorze Sent: Friday, 14 January 2005 10:26 To: zope@zope.org Subject: Re: [Zope] Format date fields Importance: High <dtml-in ZSQL_log> this is my Firebird connection <tbody> <tr> <table style=" width: 100%; text-align: left;" border="0" cellpadding="0" cellspacing="0"> </td> <td style="width: 200px; vertical-align: center;"><span style="font-family: tahoma;"><br> <small><dtml-var "LG_DATA.strftime('%Y-%m-%d')"></small></td> this is the string (since i'm Portuguese DATA means date) </tr> </tbody> </table> </dtml-in> Peter Millar wrote:Please post your code and more details about the error so that we can provide greater assistance. ____________________________________________ Peter Millar -----Original Message----- From: zope-bounces@zope.org [mailto:zope-bounces@zope.org] On Behalf OfZorze Sent: Friday, 14 January 2005 10:18 To: zope@zope.org Subject: Re: [Zope] Format date fields Importance: High Thank you Andrew. :-) But it give me another an error :-( Error Value: You are not allowed to access strftime in this context Regards Andrew Milton wrote: +-------[ Zorze ]---------------------- | Hi, | I'am new to Zope so please excuse me about some stupid questions. | | How can I format a date field from in a DTML from ZSQL Method e.i.: | | It shows 2005-01-12 22:49:33:00 | | but I want to show just 2005-01-12 Try these; <dtml-var "theDate.strftime('%Y-%m-%d')"> or <dtml-var "theDate.strftime('%F')"> (same as above, just shorter). | or change de order of the date | :01-12-2005. <dtml-var "theDate.strftime('%d-%m-%Y')">_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )