Articles in this section

See more

Error or incorrect date format when opening documents caused by incorrect date/time or region settings

Ron Silvosa
  • Updated
Follow

If there is an incorrect date or regional setting you may see the format of a date incorrect, or this can cause an error.

Issue

This article covers the following areas which could be causing an issue.

Date in incorrect format when using Edit via Browser

When opening a document using Edit via Browser, for example an Excel spreadsheet, you are seeing the date format incorrect (for example, as American format mm/dd/yyyy instead of dd/mm/yyy). When editing via excel desktop, the dates are in the required dd/mm/yyy format.

Possible Cause
The regional settings may be incorrect on your OneDrive and/or your computer's settings e

Solution
Check the Time Zone and Region on your OneDrive.

  1. Login to your onedrive.live.com 
  2. Click Settings (the cog icon at the top).
  3. Select OneDrive Settings.
  4. Go to More Settings.
  5. Select Regional Settings (under Region and Language)
  6. Set Time Zone and Region to be the setting you require.

Check your computer's Clock and Region

  1. Display computer's Control Panel (you can type Control Panel in the search)
  2. Select Clock and Region.
  3. Select Region
  4. Set this to the format required (for example, "English (United Kingdom)" or English "Australia).
  5. Click Apply
  6. Click OK.

Refresh FYI and reopen the document again to check the date format displays as required.

Return to Issue.

Error message when using Drag and Drop, Import from FYI - My Imports, Edit, Preview, Download

When trying to import documents (using Drag and Drop or via you OneDrive folder FYI - My Imports) or when using Edit, Preview or Download in FYI, an error message such as the following displays:

  • Failed to verify user identity, please check local system clock is correct before trying again.
  • We encountered an error calling Foundry.
  • Could not open this document.
  • Failed to verify user identity
  • When opening document for edit- "Failed to verify user identity, please log out and back into FYI before trying again"

Possible Cause
The date and time on your computer are incorrect due to a change over to daylight saving time.

Solution
Change the Date/Time setting on your computer as follows:

  1. In the bottom right of your primary monitor in Windows 10, right mouse click on where the date and time are displayed.
  2. Select Adjust date/time
  3. In the Settings - Date & time, set the option Set time automatically to "On".
  4. Set the option Set time zone automatically to "On".
  5. Close the Settings.
  6. Wait for a few minutes for the settings to take effect and you will see the computer time adjusts to the correct time.
  7. In FYI, Logout and then Login again.

External resource:
https://support.microsoft.com/en-ph/help/4026213/windows-how-to-set-your-time-and-time-zone

Return to Issue.

Error "We could not find a user for your email" when logging in to FYI. Daylight Saving issue.


When logging into FYI, if you are getting the error "We could not find a user for your email", refer to Error "We could not find a user for your email" when logging in to FYI. Daylight Saving issue.

Return to Issue.

Related articles

Comments

0 comments

Please sign in to leave a comment.