Date problem in Excel when data is generated from external program

[R Sathyamurthy]

Dear Friends,

We run in a Citrix environment.

We have Windows Servers installed.

Our core application resides in the Citrix Server and we use it by logging
on to the Citrix server thru the windows server.

Our Core application has many reports which can be run and ported to Excel.

I find that whever such reports are ported, the dates are interpreted
wrongly.

We generally follow a DD/MM/YY format.

However, these reports from the core system, exported to excel gets opened
as MM/DD/YY.

I tried checking the date format in the regional options and in the Excel
installation in the citrix server. But, this doesn't remedy the problem.

Look forward to solutions/ suggestions.

Regards
Murthy

 

[Hernandez, Roberto]

Try calling data from external environment in this way

CLng(Date)

 

[Sathyamurthy & Aruna]

Hi Roberto,

Thanks!

I am not calling the data from Excel at all.

It is actually my external program (non-excel, our core application which is
built on Oracle D2K) which gives me the facility of exporting report results
into Excel. It opens the Excel program and shows me the report (unformated)
in Excel.

Interestingly, some of us are having Oracle Forms installed in our PCs who
do not experience any problem with the dates. As the Excel seems to take the
date setting from our own computer.

It is only those guys who log into the core application as a Citrix
Metaframe client who face this problem. I tried changing the date format in
the Regiional Options in their individual desktop, but no avail.

Regards

Murthy

 

[Hernandez, Roberto]

Ok. Sorry
I gave that format to a DTPicker date and worked fantastic...
Regards,