I’m new to using the DataMapper and PlanetPress. I’m attempting to extract data from a .csv file and I’ve run into an issue when attempting to extract a date. I hope someone can help.
In the .csv file, the dates are written as “5th May 2022”. I believe the “th” is my problem.
I’ve set the following properties for this field:
Type = Date
Date/Time format: Custom
Pattern: ddth MM yyyy
Unfortunately, Connect isn’t able to parse the data using these settings. Anyone know if this is achievable?