troubleshooting Question

Dates not recognized when downloaded from Peoplesoft

Avatar of Davisron867
Davisron867Flag for United States of America asked on
Microsoft Excel
2 Comments1 Solution264 ViewsLast Modified:
I'm experiencing some unexpected behavior in a PeopleSoft nVision matrix report.

The report layout has a date code in Row 2, which is hidden

-Cell F2 has the PeopleSoft code %ASD% to return the Report Date, so for Apr 30, 2011,
the formula returns '2011-04-30 (including the apostrophe).

-Cell F10 is a column header with the formula =Text(F2,"mmm") and should display Apr

Both cells are formatted as General.

The result of the text formula in cell F10 has always been Apr,but when we run the same layout in a new production environment residing offshore, the result in cell F10 is the number 4 instead of Apr.

The column header in cell F10 will magically update and resolve to "Apr" if you
-expand the hidden row (row 1) with the %ASD% formula, or
-activate either cells F1 or F10.

But, we dont want to have to manually intervene to get the header to display the month as Apr. I could use VBA to activate cells in the This Workbook object, but I'd like to understand why this is happening and if there's a non-VBA solution.

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros