My numbers are correct. You must use a timestamp that reflects 23:59:59.999 in UTC/GMT 0:00 on the desired date, not 23:59:59.999 in your local time zone (e.g. EDT,or UTC -4:00).
When I attempt to update one of my own list filters with the EDT timestamp 1560916799999 (Tuesday, June 18, 2019 at 23:59:59.999 EDT):
{
"status": "error",
"message": "Dates with greater than filters must specify the end of the day as the timestamp",
"correlationId": "fb2eba9a-6015-427c-9989-7cbeae9fced0",
"requestId": "eda7e04e7010e7959ae4ad6cce1d39a1"
}
However, when I use a timestamp reflecting Tuesday, June 18, 2019 at 23:59:59.999 in the UTC/GMT time zone — 1560902399999:
Date day = new Date();
Calendar cal = Calendar.getInstance();
cal.setTime(day);
cal.set(Calendar.HOUR_OF_DAY, cal.getMaximum(Calendar.HOUR_OF_DAY));
cal.set(Calendar.MINUTE, cal.getMaximum(Calendar.MINUTE));
cal.set(Calendar.SECOND, cal.getMaximum(Calendar.SECOND));
cal.set(Calendar.MILLISECOND, cal.getMaximum(Calendar.MILLISECOND));
cal.setTimeZone(TimeZone.getTimeZone("UTC"));
My numbers are correct. You must use a timestamp that reflects 23:59:59.999 in UTC/GMT 0:00 on the desired date, not 23:59:59.999 in your local time zone (e.g. EDT,or UTC -4:00).
When I attempt to update one of my own list filters with the EDT timestamp 1560916799999 (Tuesday, June 18, 2019 at 23:59:59.999 EDT):
{
"status": "error",
"message": "Dates with greater than filters must specify the end of the day as the timestamp",
"correlationId": "fb2eba9a-6015-427c-9989-7cbeae9fced0",
"requestId": "eda7e04e7010e7959ae4ad6cce1d39a1"
}
However, when I use a timestamp reflecting Tuesday, June 18, 2019 at 23:59:59.999 in the UTC/GMT time zone — 1560902399999: