datagrid format question

Discussion in 'ASP .Net Datagrid Control' started by ibeetb, Jul 14, 2004.

  1. ibeetb

    ibeetb Guest

    I have two fields, both are date and time fields that populate two of the
    columns in my datagrid. The format from the database is: 7/14/2004 09:14:00
    AM for both (the times would be different - one is start time one is stop
    time)

    I need this to be formatted in a way that I can subtract the two times and
    get a time interval. Anyone know????
     
    ibeetb, Jul 14, 2004
    #1
    1. Advertising

  2. ibeetb

    Rick Spiewak Guest

    You can get the time interval by converting both date strings to date types
    and computing the difference.

    "ibeetb" <> wrote in message
    news:...
    > I have two fields, both are date and time fields that populate two of the
    > columns in my datagrid. The format from the database is: 7/14/2004

    09:14:00
    > AM for both (the times would be different - one is start time one is stop
    > time)
    >
    > I need this to be formatted in a way that I can subtract the two times and
    > get a time interval. Anyone know????
    >
    >
     
    Rick Spiewak, Jul 15, 2004
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Brian Candy
    Replies:
    2
    Views:
    1,179
    Janaka
    Feb 18, 2004
  2. Andy
    Replies:
    7
    Views:
    6,296
    Roedy Green
    May 10, 2004
  3. shannon
    Replies:
    1
    Views:
    8,618
  4. shannon
    Replies:
    0
    Views:
    581
    shannon
    Feb 1, 2006
  5. Replies:
    6
    Views:
    473
    Thomas Ganss
    Jan 15, 2006
Loading...

Share This Page