Hi,

When I display the Date format as "D-Mmm-YY", in excel getting the green flag error with error message "This cell contains a date string represented with only 2 digits of the year.". In excel output the "Format Cells" shows the Category as General. But when I press enter in the value, then the Category changes to Custom (with d-mmm-yy) and remove the green flag also.
The green flag is not coming for "D-Mmm-YYYY" format, but user sticks into "D-Mmm-YY" format only.

Can anyone help me out remove the green flag message for "D-Mmm-YY" format in excel.

Please see below sample code I tried out.

 DEFINE FILE EMPDATA
DATE1/HYYMD = HDTTM(HIREDATE, 8, DATE1); 
END

TABLE FILE EMPDATA
PRINT 
DATE1/HdMtY-
DATE1/HdMtYY-

ON TABLE PCHOLD FORMAT EXL2K

ON TABLE SET STYLE *
TYPE=REPORT, BORDER=.1, $
ENDSTYLE

END  

I am using WebFOCUS 7.7.03 version.

Thanks,
Kumaravel.M

This message has been edited. Last edited by: Kerry,

Hi Kumaravel,

From our technicals: Check under Excel Options for error checking under Formulas in order to turn this off.

Cheers,

Kerry

Hi Kerry,

Thanks for your reply. Actually there will be more number of end users going to use this report, so we have to guide each user to turn off "error checking" in their excel. This is very hard and not possible.

Is any other way to turn off the error checking option from our WebFOCUS reporting side itself?

Once again thanks for your suggestion.

Thanks,
Kumaravel.M

Hi Kumaravel,

If this gets more involved, I would strongly suggest that you open a case with Customer Support Services for additional assistance. Please call 1-800-736-6130, or access online at InfoResponse.

Cheers,

Kerry