| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| date and hours issue | Excel Discussion (Misc queries) | |||
| Date conversion issue "^" symbol | Excel Discussion (Misc queries) | |||
| How do I report a Date Format bug in Excel 2003 to Microsoft ? | Excel Discussion (Misc queries) | |||
| Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
Linear Mode
