• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 230
  • Last Modified:

Converting a time field into a number

How can I convert a  time field in Crystal Report to be a number field.

I have a time field in secinds and I need it be a nubmer field so I can divide against it.
1 Solution
I have a feeling Crystal Reports can only provide data in the format in which the source data is kept.  If you change the source data that will fix it.  Of course if you are running this straight from a source table then that may not be a feasible exercise, so you may want to use a view as your source and use a CONVERT statement in the SELECT clause to convert your field to numbers.

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now