Date syntax in GMAINT or diagnostic utility

The correct syntax for the selection criteria for a Sage X3 date field is:  [DD/MM/YYYY]

 Classified as follows  "DD=Day", "MM=Month" and "YYYY=Year"

Example:

Criteria using CREDAT in table for records with a CREDAT less than March 12th, 2020.

CREDAT<[12/03/2020]