VB Crystal Report, Calculations using date formats in Crystal 8

Calculations using date formats in Crystal 8

Author	Message
fatou.n.. #1 / 5	Calculations using date formats in Crystal 8 I am creating a report using Crystal 8 to calculate the total time a helpdesk analyst has worked for a particular day. I am trying to add time variables together to get a total time( in hrs & mins) for that person. My time variables are in this format (hh:mm). My data is coming from a SQL Server 7 db where the data type is defined as string. I think I would have to convert the variable to number first, do the calculation, and then convert the result back to time. Could someone please help me if you have come across any code that can do this conversion? Thank you. Fatou N'Jie Sent via Deja.com http://www.--*.com/
Tue, 15 Jul 2003 06:06:27 GMT

BFin #2 / 5	Calculations using date formats in Crystal 8 Search the Seagate site for ufljul.exe It has a couple of custom functions for converting dates to & from Julian dates. Brian Quote: > I am creating a report using Crystal 8 to calculate the total time a > helpdesk analyst has worked for a particular day. I am trying to add > time variables together to get a total time( in hrs & mins) for that > person. My time variables are in this format (hh:mm). My data is > coming from a SQL Server 7 db where the data type is defined as > string. > I think I would have to convert the variable to number first, do the > calculation, and then convert the result back to time. Could someone > please > help me if you have come across any code that can do this conversion? > Thank you. > Fatou N'Jie > Sent via Deja.com > http://www.deja.com/
Tue, 15 Jul 2003 22:32:23 GMT

#3 / 5	Calculations using date formats in Crystal 8
Fri, 19 Jun 1992 00:00:00 GMT

fatou.n.. #4 / 5	Calculations using date formats in Crystal 8 I would like to clarify my problem. I have a report that has time fields defined as string. The data for the report is imported from a SQL Server 7 db where all the fields are defined as text. I am trying to add all the times to give me a total time for each analyst. My question is how do I do this? I know I probably have to convert the string data type to some numeric in order to get the total time. Does anyone have any code I can use to do this? I have been working on this the past week and have not come up with anything that can work. Please help. Quote: > Search the Seagate site for ufljul.exe It has a couple of custom functions > for converting dates to & from Julian dates. > Brian > > I am creating a report using Crystal 8 to calculate the total time a > > helpdesk analyst has worked for a particular day. I am trying to add > > time variables together to get a total time( in hrs & mins) for that > > person. My time variables are in this format (hh:mm). My data is > > coming from a SQL Server 7 db where the data type is defined as > > string. > > I think I would have to convert the variable to number first, do the > > calculation, and then convert the result back to time. Could someone > > please > > help me if you have come across any code that can do this conversion? > > Thank you. > > Fatou N'Jie > > Sent via Deja.com > > http://www.deja.com/ Sent via Deja.com http://www.deja.com/
Sun, 20 Jul 2003 00:06:02 GMT

Bruce Ferguso #5 / 5	Calculations using date formats in Crystal 8 CR8 has a CDate function that might be of help and it will recognise regional settings, or you might want to try DTSToDate but that expects your dates to be in the string format YYYY/MM/DD HH:MM:SS Quote: > I would like to clarify my problem. I have a report that has time > fields defined as string. The data for the report is imported from a > SQL Server 7 db where all the fields are defined as text. I am trying > to add all the times to give me a total time for each analyst. My > question is how do I do this? I know I probably have to convert the > string data type to some numeric in order to get the total time. Does > anyone have any code I can use to do this? I have been working on this > the past week and have not come up with anything that can work. Please > help. > > Search the Seagate site for ufljul.exe It has a couple of custom > functions > > for converting dates to & from Julian dates. > > Brian > > > I am creating a report using Crystal 8 to calculate the total time a > > > helpdesk analyst has worked for a particular day. I am trying to > add > > > time variables together to get a total time( in hrs & mins) for that > > > person. My time variables are in this format (hh:mm). My data is > > > coming from a SQL Server 7 db where the data type is defined as > > > string. > > > I think I would have to convert the variable to number first, do the > > > calculation, and then convert the result back to time. Could > someone > > > please > > > help me if you have come across any code that can do this > conversion? > > > Thank you. > > > Fatou N'Jie > > > Sent via Deja.com > > > http://www.deja.com/ > Sent via Deja.com > http://www.deja.com/
Thu, 24 Jul 2003 13:39:42 GMT

Page 1 of 1

[ 5 post ]