Sta: with Dates

Paul Mulroney pmulroney at
Thu Jul 21 12:09:00 UTC 2022

Hi Mats,

> On 21 Jul 2022, at 3:06 pm, ADJob <mats at> wrote:
> Hi,
>> In our experience, this line becomes eg 'WHERE invoice_date>='21 JUL 2022', which produces an SQL error
> Working in a country that followed ISO standards for decades this is no problem
> Calculate #FD as 'y-M-D'     ;; Set to ISO in startup task

We are not so fortunate as to live in such a logical country!  We still need to display the date in the generally accepted format for our region so we chose to convert the dates in the query instead.  Still, this isn't a bad way to go!


People used to laugh at me when I would say "I want to be a comedian", well nobody's laughing now.
Paul W. Mulroney                                            We Don't Do Simple Pty Ltd 
pmulroney at       Trading as Logical Developments                   ACN 161 009 374 
Ph: +61 8 9458 3889                                       86 Coolgardie Street
                                                                         BENTLEY  WA  6102

More information about the omnisdev-en mailing list