Sta: with Dates
pmulroney at logicaldevelopments.com.au
Thu Jul 21 12:09:00 UTC 2022
> On 21 Jul 2022, at 3:06 pm, ADJob <mats at adjob.se> wrote:
>> 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 https://sv.wikipedia.org/wiki/ISO_8601
> 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 logicaldevelopments.com.au Trading as Logical Developments
www.logicaldevelopments.com.au ACN 161 009 374
Ph: +61 8 9458 3889 86 Coolgardie Street
BENTLEY WA 6102
More information about the omnisdev-en