Re: [Zope] Need to use a 'date' data type in sqltest

Jones, David H writes:

I need to include a test of a date in a DTML variable referenced in a sqltest tag in ZSQL. From reading documentation and testing, it does not appear that the 'date' data type is supported. As fas as I know, SQL databases vary greatly in the representation of times and dates.

If your database accepts string representations for date fields, you could use an "dtml-var" (rather than "dtml-sqltest") with an appropriate "fmt" argument. Dieter