Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
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!
5