[jenrandle18]

I have successfully imported pdf files from Google Drive for years. Recently, I get the following error:
java.lang.illegalArgumentException:Negativetime

I am the owner of the Google Drive. I have no idea what this message means or how to fix it.

[Zubersoft]

That's very strange - it would indicate one of the files in your Google Drive account may have an invalid date created or last modified timestamp. Are you getting that error when you try to access your Google Drive folder? Or after selecting the files to import?

Mike

[jenrandle18]

I get the error message after it tries to import the files. It sees to go through the normal process, but then the files are not imported, and I receive this message.

[Zubersoft]

If you upload a new PDF to Google Drive, then turn around and try to import that PDF, do you encounter the same issue? I just want to verify whether this is impacting all PDFs in your account or only specific ones. No other users have reported this issue, so I'm not sure what to make of it yet. I have not changed anything with the Google Drive integration in a long time.

Mike

[jenrandle18]

I checked the files in Google Drive, and they all listed Dec 31, 1600 as the last modified date. I uploaded the files go Google Drive again, replacing what was there, and then they worked importing into Mobilesheets. So, it appears there is not a problem with Mobilesheets. Now I need to find out why Google is acting so strangely. Thanks for your time.

[jenrandle18]

This was only happening with files that I had just uploaded to Google Drive and then tried to import to Mobilesheets. For some unexplained reason, they showed up as Dec 31, 1600 as the last modified date. I'll pursue this issue with Google and see if I can get a resolution.

[Zubersoft]

That is highly unusual. I hope Google can provide an explanation, as I've never seen that happen before.

Mike