Hi,
if I use the SQL statement only for one table:
SELECT ID, BUSENA, KLIENTO_ID, ADRESAS, REG_DATA, ATL_DATA FROM REG_ZURNALAS ORDER BY REG_DATA DESC
I can to set “group by” for date field (see atachment group_by_yes.jpg).
if I use the SQL statement with some tables:
SELECT REG_ZURNALAS.ID, REG_ZURNALAS.BUSENA, REG_ZURNALAS.KLIENTO_ID, PAJUNGIMAI.PAVADINIMAS, PAJUNGIMAI.IP_ADDRESS,
REG_ZURNALAS.ADRESAS, REG_ZURNALAS.REG_DATA, REG_ZURNALAS.ATL_DATA FROM REG_ZURNALAS
LEFT JOIN PAJUNGIMAI ON (PAJUNGIMAI.ID = REG_ZURNALAS.KLIENTO_ID)
ORDER BY REG_ZURNALAS.REG_DATA DESC
I can’t to set “group by” for date field (see atachment group_by_no.jpg).
And the date field mask not working (see mask_field.jpg).
BAD.pdf (432 KB)