Need suggestion for set date format using oracle report desformat for excel report

Question

I have a oracle report which is to display a set of values and it can be generated both as pdf and csv formats. Excel doesnt consider the trainling zeros,so i tried the following way.

       IF :DESFORMAT='SPREADSHEET' THEN
               :CP_2:= '="'||:cmdt_grp_cd||'"';
       ELSE
               :CP_2:=:cmdt_grp_cd;
       END IF;

in the same how to set date values kindly suggest me?

Consider accepting answers to your previous questions first? http://stackoverflow.com/questions/33030316/internal-functionality-of-dual-table — Lalit Kumar B, Oct 28 '15 at 05:38

score 0 · Answer 1 · edited Mar 20 '17 at 10:18

0

Maybe use the DATE like this:

:CP_2:= '=DATE('||TO_CHAR(:cmdt_grp_cd, 'YYYY;MM;DD')||')';

Problem is, the separator can be , or ; (or anything else actually) depending on your local windows settings.

I found this one https://superuser.com/a/686415, however I did not test it.

edited Mar 20 '17 at 10:18

Community

1
1

answered Oct 28 '15 at 08:43

Wernfried Domscheit

54,457
9
76
110

thank U,Wernfriend ,its working ,but in the output m getting '/' ,then how to get dot(.) like 2012.12.12 kindly suggest me – MastanSky Oct 28 '15 at 11:34
Is `cmdt_grp_cd` a string data type? – Wernfried Domscheit Oct 28 '15 at 11:42
its date datatype ,the result is comming 24/11/2015, but i need 24.11.2015 kindly suggest me – MastanSky Oct 28 '15 at 12:16
Ah, you mean the display format in Excel. No idea, I assume this depends on the local PC settings. – Wernfried Domscheit Oct 28 '15 at 12:58

Need suggestion for set date format using oracle report desformat for excel report

1 Answers1