Converting a time field into a number

Posted on 2005-05-10
Last Modified: 2010-04-17
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.
Question by:mikevere
    1 Comment
    LVL 6

    Accepted 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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Suggested Solutions

    Title # Comments Views Activity
    How to silent print from safari browser 6 97
    hasOne  challenge 59 64
    find a node in VST 2 36
    countX 22 49
    Here we come across an interesting topic of coding guidelines while designing automation test scripts. The scope of this article will not be limited to QTP but to an overall extent of using VB Scripting for automation projects. Introduction Now…
    A short article about problems I had with the new location API and permissions in Marshmallow
    In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
    In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now