Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The most problematic part of the integration data is insert correct and valid One of the most challenging aspects of data integration is ensuring the correctness and validity of date and time entries.

tSheet is using Googles utilizes Google's datetime object and input validation mechanisms to manage this data, but sometimes mistake can be make. Usually the mistake happens errors can still occur. These mistakes are most common when date and time data is paste from external sourcepasted from external sources. It is important to double-check these entries for accuracy to avoid potential issues with your data integration process.

...

In case If the date and time is entered are not valid or the imported date data is not correctincorrect, follow the next steps.

...

these steps to address the issue:

  1. set the spreadsheet localization.,In

    1. go to the File Settings

    Choose
    1. ,

      Image Added
    2. choose your location and confirm selection by

    Save settings
    1. pressing ‘Save settings’.

...

  1. If the step 1 have did not helped, mark date cells with the date and set formatting type again.,

    1. Mark mark cells with the date time.,

    2. Go go to Format → Number → Date time

...

    1. and select ‘Date time’ and that should help.

...

Info

If you continue to experience issues with correctly entering or sending data using Google tSheet after attempting the suggested fixes, please do not hesitate to contact us for assistance. Our support team is ready to help you resolve any problems and ensure that your data integration is successful.