NiFI: how can i convert string to date

Hi,

Check your "Date Format" setting in the CSVReader service where you can specify a format string to interpreting text as a date.  At a guess either "M/dd/yyyy" or M/dd/yyyy" would work based on the data sample provided. 

More information on date format strings here: https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html

As an aside, I don't think the CSVRecordSetWriter settings are much use here as you're terminating all outbound PutDatabaseRecord relationships.

Hope that helps.

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.