Allow Users to Configure Date Format
Allow users to configure date format.
We use the date format MM.DD.YYYY. However, when we use Bulk Updater, it transposes our format to DD.MM.YYYY. As a result, we changed our date fields to text fields.
Now they don't sort correctly. So we need to change our date fields back to a date format so that they can sort correctly. This is the only way that I can determine how to do that:
The only way to change a text field to a date field is:
Create a bulk update sheet from your library
Make sure all the dates are in dd/MM/yyyy format (I think you can do that automatically in the spreadsheet)
Go into the Library, Delete the Date Field (Field Type - Text) - You'll need to remove it from all the views, etc.)
Add a new date field in the date (field type) format, Save
Download a new Bulk Updater Spreadsheet, with the new Date field.
Make sure both Bulk Updater Spreadsheets are sorted the same way.
This should work, but now our date formats are DD.MM.YYYY