CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4
  1. October 2nd, 2001, 06:39 PM #1
    uni
    uni is offline Member
    Join Date
    Sep 2000
    Posts
    58

    Date - Help!!!!!!!!

    Hi,

    Does anyone have some code that converts a date\time datatype into a double datatype.

    eg. convert 9:45pm into 21.75

    Please help as is urgent.

    Thanks.

    Reply With Quote Reply With Quote
  2. October 2nd, 2001, 08:55 PM #2
    d.paulson
    d.paulson is offline Member +
    Join Date
    Jan 2000
    Location
    Saskatchewan, Canada
    Posts
    595

    Re: Date - Help!!!!!!!!

    Text1 = CDbl(Time) * 24


    David Paulson

    Reply With Quote Reply With Quote
  3. October 2nd, 2001, 09:15 PM #3
    uni
    uni is offline Member
    Join Date
    Sep 2000
    Posts
    58

    Re: Date - Help!!!!!!!!

    That works great. However, there is one more problem. The time is coming from a date/time field and therefore I need to first split the time away from the date.

    DO YOU KNOW HOW TO DO THIS?

    THANKS HEAPS.

    Reply With Quote Reply With Quote
  4. October 2nd, 2001, 09:26 PM #4
    d.paulson
    d.paulson is offline Member +
    Join Date
    Jan 2000
    Location
    Saskatchewan, Canada
    Posts
    595

    Re: Date - Help!!!!!!!!

    debug.Print formatdatetime(now,vbShortTime)

    David Paulson

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules




Click Here to Expand Forum to Full Width

Featured