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 datetime utilizes Google's date-time 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 source.
...
In case date and time is not valid or imported date is not correct, follow the next steps.
Set the spreadsheet localization.
In File → Settings Choose your location and confirm selection by Save settings
...
If the step 1 have not helped, mark cells with the date and set formatting again.
Mark cells with the date time.
Go to Format → Number → Date time
...
pasted from external sources. It is important to double-check these entries for accuracy to avoid potential issues with your data integration process.
...
If the date and time entered are not valid or the imported data is incorrect, follow these steps to address the issue:
set the spreadsheet localization,
go to the File → Settings,
choose your location and confirm the selection by pressing ‘Save settings’.
If step 1 did not help, mark the date cells and set the formatting type again.,
mark cells with the date time,
go to Format → Number 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. |