Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hello,

Based upon the data in the comments the problem in the date field. It is in the incorrect format. Locale does not matter here. It must be in YYYY-MM-DD format including the hyphens. Your date is YYYYDDMM without the hyphens.

Tested in Tools->SQL:

image description

Status #2 was using your date; status #3 is with corrected date format.

Hello,

Based upon the data in the comments the problem is in the date field. It is in the incorrect format. Locale does not matter here. It must be in YYYY-MM-DD format including the hyphens. Your date is YYYYDDMM without the hyphens.

Tested in Tools->SQL:

image description

Status #2 was using your date; status #3 is with corrected date format.