E-NV: NVision Excel Report's Date Fields Are Prefixed With An Apostrophe (Doc ID 2261805.1)

Last updated on JUNE 19, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Symptoms

When running nVision reports, an apostrophe is added before each date value.

Steps

-------
The issue can be reproduced at will with the following steps:
1. Login to PIA
2. Navigate to Reporting Tools > PS/nVision > Define Report Request
3. Run a report
4. Notice the apostrophe added to each date value in the output

Note: If the NvsDateToNumber is added to the nVision layout, the issue does not occur.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms