TLDR, but I think I got your idea. It’s about date manipulation to correspond to MM/dd/yyyy format that is enforced for bank imports (which doesn’t make sense to me).
The main problem is if you have your system date set as dd/MM/yyyy then your system will read some (e.g. 2/3/2021) as date and flip d and M and others (e.g. 2/28/2021) as text and keep current order which makes the solutions complicated. And the worst part is, it has nothing to do with what you set your preferences.
If the system has to enforce one date format for imports and exports, that format should be ISO (yyyy-MM-dd) because:
- It’s the default date for servers, databases and systems
- regardless of set preferences, the OS will never confuse it with any other format, it will either take the whole thing as date or as text unlike what I described earlier, so the solutions is simpler.
- To import into manager, you just have to change the cell formating of the date column in excel and that’s it.
I already proposed this here
The issue appeared to have been solved and then returned.
If I didn’t get the idea of the OP, please let me know.