Discussions
NetSuite Admin Tips | Bank Statement Parsers SuiteApp version 21.2.0 - Acceptable Date Formats
Since Bank Statement Parsers SuiteApp version 21.2.0, you can now use a CSV parser plug-in to import bank statement files in CSV format into NetSuite. But do you know the acceptable date formats to use? Here's a breakdown to help you out!Date formats can be:
- 1-3 M (month) characters
- 1-2 D (day) characters
- 2-4 Y (year) characters
You may or may not use a separator but in case you want to, these are allowed:
- Hyphen (-)
- Slash (/)
- Period (.)
- Space
Here are some examples:
- MMM DD YYYY
- DD/MM/YYY
- M-D-YYYY
- DDMMYYYY
- YYYY.MM.DD
Which of these date formats have been most useful for you when importing your bank statement files? Are there any other formats you hope can be included to fit in your business needs? Lets us know!