Sta: with Dates

ADJob mats at adjob.se
Thu Jul 21 07:06:24 UTC 2022


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

/Mats




More information about the omnisdev-en mailing list