A value in the OWC grid is changed into a date

Table of Contents (index)
Problem Type : Databases
Problem Category : Product components

This problem is due to use of an Outlook Web Component spreadsheet friendly string, like 1aug2, 1oct3, 10jun2.

When these values are added to the spreadsheet they are automatically changed into date format. If the user wants to use date there will be no issue at all.

The problem comes when a user wants to use for example 1aug2 as a string value, NOT a date value. Then it will convert into a date.

1. The value is written in the grid



2. The value is changed to the date format of the system



If someone for example has a metadata name "1aug2" it will be changed into a date by OWC. Therefore, if you have this problem, please change the data, like 1aug2 to 1augg2.

If you use TimeCard, the value might look good in the you Personal Settings, but you will see that the value is missing when you report.

Table of Contents (index)