imported impromtu report date issue - fix by format or formula
 

I am saving a cognos imrpomtu report in excel but not formatted up by report
writer.

It is giving me trouble in date fileds maybe.

I need to understand that excel is reading date right

I think the filed is orginally a date and time but not sure.

Do I use a formula to fix or secire this date or do I just format as date in
excel.

If I format date and time I get the time as 12am un all fields so i assume
from this no time was exported

wow- thanks

Hi

What does the date field show in Excel, when formatted as General?

Andy.

"Todd F." wrote in message
...
I am saving a cognos imrpomtu report in excel but not formatted up by
report
writer.

It is giving me trouble in date fileds maybe.

I need to understand that excel is reading date right

I think the filed is orginally a date and time but not sure.

Do I use a formula to fix or secire this date or do I just format as date
in
excel.

If I format date and time I get the time as 12am un all fields so i assume
from this no time was exported

wow- thanks

please disregard this question terrible misunderstanding

thanks for time

"Andy" wrote:

Hi

What does the date field show in Excel, when formatted as General?

Andy.

"Todd F." wrote in message
...
I am saving a cognos imrpomtu report in excel but not formatted up by
report
writer.

It is giving me trouble in date fileds maybe.

I need to understand that excel is reading date right

I think the filed is orginally a date and time but not sure.

Do I use a formula to fix or secire this date or do I just format as date
in
excel.

If I format date and time I get the time as 12am un all fields so i assume
from this no time was exported

wow- thanks

please disregard

"Todd F." wrote:

I am saving a cognos imrpomtu report in excel but not formatted up by report
writer.

It is giving me trouble in date fileds maybe.

I need to understand that excel is reading date right

I think the filed is orginally a date and time but not sure.

Do I use a formula to fix or secire this date or do I just format as date in
excel.

If I format date and time I get the time as 12am un all fields so i assume
from this no time was exported

wow- thanks