I am having a hard time getting a simple input string field (which is a date) from a CSV file that is in the following format: "3/7/2024 12:39:42.784 PM" to map to an awaiting output definition as a date field.
Writing from input to output as String ... JSON output, works just fine. But, any time I try to write to a GeoEvent Def that has a date field to hold this data - I get NULL results. I've looked through many of the link available via the Esri community and no luck. I've tried adding this calc: replaceAll(Field3, '(\d+)[/](\d+)[/](\d+)', '$3-$1-$2T00:00:00') ... and it works until I apply it to an awaiting date field. I've tried setting the date format for the Input CSV.
Any guidance is greatly appreciated.