Sta: with Dates

[Paul Mulroney]

Hi Mats,

> On 21 Jul 2022, at 3:06 pm, ADJob <mats at adjob.se> 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 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!

Regards,
Paul.


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