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)


"R Sathyamurthy" <samaruna@omantel.net.om> escribió en el mensaje
news:u3LPXex1FHA.2880@TK2MSFTNGP12.phx.gbl...
> 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
>
>

[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" <m21477@ustccax.kcc.com> wrote in message
news:11lkpd7db2s62d@corp.supernews.com...

> Try calling data from external environment in this way
>
> CLng(Date)
>
>
> "R Sathyamurthy" <samaruna@omantel.net.om> escribió en el mensaje
> news:u3LPXex1FHA.2880@TK2MSFTNGP12.phx.gbl...
>> 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]

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

"Sathyamurthy & Aruna" <aruna.sam@gmail.com> escribió en el mensaje
news:%23HSuaj41FHA.3524@tk2msftngp13.phx.gbl...
> 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" <m21477@ustccax.kcc.com> wrote in message
> news:11lkpd7db2s62d@corp.supernews.com...
>
>> Try calling data from external environment in this way
>>
>> CLng(Date)
>>
>>
>> "R Sathyamurthy" <samaruna@omantel.net.om> escribió en el mensaje
>> news:u3LPXex1FHA.2880@TK2MSFTNGP12.phx.gbl...
>>> 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
>>>
>>>
>>
>>
>
>