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]