When using the NPS Import function, it can be very frustrating that there are only 4 date formats available when the native date format for Excel is MM/DD/YYYY and this is not one of the 4 options. If you save the file you want to import as a .csv and then reopen it in Excel for any reason, it will revert all of those dates to the native format even if you have changed them in the version you had saved to your .csv file (because the .csv removes all formatting and then Excel reinterprets the dates into its format when you open it). It would be much easier if the import tool could accept date formats that are native to Excel.
Be the first to reply!
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.