T
Todd F.
Sorry for lengthy question but need to master this topic - thanks for time
also I need to do ongoing date work so i wan to know the best way ongoing not
a quicky solution if possible.
I will make use of any external sites or resources you point me tward.
THE QUESTION:
I have reports coming out of cognos imromptu that have the following format
in the interval or time field - I need to use case created and case closed
(impromptu) allot but these are also general excel date time format questions:
In impromptu the date field is formatted like "000 00:00:00.000"
day hr
min sec etc.
When I export to excel I get the following in the field and in the formula bar
Create date cell " 1/2/05 17:04" , in formula bar I get "1/2/2005
5:04:30pm"
Close date cell "1/2/2005 20:35" , in formula bar I get "1/2/2005
8:35:10 pm"
The calculated field of close date less the create date from report writer (
impromptu gives the following in excel
cell " 0 3:30" , in formula bar I get "1/0/1900 3:30:40 AM"
Now in Excel if I do a calculation on the two dates I get the following:
cell " 0 3:30 , in formula bar I get "c11-b11"
Something you should know - I can create afield in report writer that will
dump the count of days from 1900 so i get a cleannumber calculation. Then I
can do celan calcs in excel.
However I would like to know how to handle dates and not rely on the days
from 1900 method
? is there a way I should try to format in report writer - limted!
? what is the soundest way to handle dates with time in them so I can get
clean hours and minutes - some time I need to knwo hours been created and
closed , sometimes I need count of days open.
I do need to get clean fields with year, month, and day so I guess zi need
to format so a calc or parse can be done - any thoughts. I would even be
interested in calculating the week of the year.
I work in a 24/7 tech support company - working as an analyst for a point of
reference so the pressure is off on week days & weekend issues but I would
liek to learn about this as well as handeling holidays.
Again thank you for your personal time on this.
also I need to do ongoing date work so i wan to know the best way ongoing not
a quicky solution if possible.
I will make use of any external sites or resources you point me tward.
THE QUESTION:
I have reports coming out of cognos imromptu that have the following format
in the interval or time field - I need to use case created and case closed
(impromptu) allot but these are also general excel date time format questions:
In impromptu the date field is formatted like "000 00:00:00.000"
day hr
min sec etc.
When I export to excel I get the following in the field and in the formula bar
Create date cell " 1/2/05 17:04" , in formula bar I get "1/2/2005
5:04:30pm"
Close date cell "1/2/2005 20:35" , in formula bar I get "1/2/2005
8:35:10 pm"
The calculated field of close date less the create date from report writer (
impromptu gives the following in excel
cell " 0 3:30" , in formula bar I get "1/0/1900 3:30:40 AM"
Now in Excel if I do a calculation on the two dates I get the following:
cell " 0 3:30 , in formula bar I get "c11-b11"
Something you should know - I can create afield in report writer that will
dump the count of days from 1900 so i get a cleannumber calculation. Then I
can do celan calcs in excel.
However I would like to know how to handle dates and not rely on the days
from 1900 method
? is there a way I should try to format in report writer - limted!
? what is the soundest way to handle dates with time in them so I can get
clean hours and minutes - some time I need to knwo hours been created and
closed , sometimes I need count of days open.
I do need to get clean fields with year, month, and day so I guess zi need
to format so a calc or parse can be done - any thoughts. I would even be
interested in calculating the week of the year.
I work in a 24/7 tech support company - working as an analyst for a point of
reference so the pressure is off on week days & weekend issues but I would
liek to learn about this as well as handeling holidays.
Again thank you for your personal time on this.