I wanted to make this easier for the future so I am trying to correctly format the dates of the documents. I went ahead and added this within my Java code
LocalDateTime currentDateTime = LocalDateTime.now();
DateTimeFormatter format = DateTimeFormatter.ofPattern("yyyy-MM-dd'T'HH:mm:ss.SSS'Z'");
String isoFormattedDate = currentDateTime.format(format);
and received the expected output, which now the collection has a field called isoFormattedDate, which has
isoFormattedDate: "2023-08-21T09:27:32.581Z"
within the document, along with other fields.
Although, when I go to create a chart first thing I notice is the isoFormattedDate field is not present within the collection, so I press “Add Fields” and then look it up explicitly and it adds it in. Following this, when I go to move that field into the “Filter” category, I do not receive what you were showing me in a previous reply. I get this
Is it because the date field is still not correctly formatted? Thanks.