Search results for query: *

The output is displaying 4 hour ahead of the actual output. What needs to be changed on the formula. I am new to crystal and not sure of creating formulas. Thank You!

Actually what is you showed as being returned might work.

I think the format on the db might actually be unix time.

The number represents the Time for Call 1 from a remote system and call 2. A system auto-generated report the data from db actually displays as 10/21/08 11:12. The number in the db is in the following format 1222167895. We are looking to create it in crystal so we can kick it off anytime and...

I believe the number represents date and time so I need to have the output display in standard date & time, 10/21/2008 11:12:00pm. Any help would be great.

This is for Crystal Reports XI.

I need to convert the time_in and time_out data from a number to standard time. Number currently displays as 10 digit number, eg. 1222167895, into standard time 11:12:00pm. Does anyone have a formula for this conversion.

Never mind I found it.

Is it possible to page break a crystal report by a specific group. Working on a nursing report that currently has nurse and subreport has patients assigned to that nurse. Person who is using the report asked if we could have the report broken up so the next page of the report would display a...

Thank You for your help both lbass and kskid.

That works just fine. Thank You. You wouldn't happen to know a formula to fine the difference in time?

I believe the first formula was almost there. right(begin,2),0) was highlighted when the too many arguments message appears. The second formula does not work at all. Thank You for your response.

I receive a message that too many arguments have been given for this function. Below is the formula I have. stringvar begint := totext({visit.begin_time},"0000"); time(left(begint,2),right(begint,2),0)

Working on a report where the time an episode starts and ends is displayed as a number field which is actually military time. I need to have the report convert it to standard time. begin time end time 2015 2215 1125 1211