Hi @MattWho ,   Thanks for the response.   I'll happily create a feature request, though I wasn't sure if I was missing something obvious that would meet my objective/requirements.   Thank you for clarifying, I'll go take a look at the links you provided (admittedly I had missed the mailing lists, oops).   Kind regards   Mark   ... View more

Hi,   I've just noticed your date strings in the sample aren't consistent which will make things difficult I think.   For example in line 1 your OrderDate format is "M/dd/yyyy" (single digit month) and in ship date it seems to be "MM/dd/yyyy" (double digit month).  For the CSV to work correctly all of your date fields would need to adhere to the same format I believe.   You can do a couple of things to resolve this:   Fix it in the source.  The best option in my opinion, if possible. Clean the data in NiFi before it arrives at the PutDatabaseRecord processor. Unfortunately the second is a touch beyond my current level of expertise, but if I was you I would explore either ReplaceText processor with the appropriately regex expression, or a an UpdateRecord processor with a SQL like statement to update this field in the flowfile - note though this would would require a separate CSVReader service that reads your data as strings.   Good luck. ... View more