Results 1 to 4 of 4

Thread: How to change number to daet

  1. Oct 27th, 2000, 09:14 AM #1
    Gary.Lowe
    Gary.Lowe is offline

    Thread Starter
    Fanatic Member Gary.Lowe's Avatar
    Join Date
    May 2000
    Location
    In my sphere of influence
    Posts
    621

    Angry

    Hi All

    How do I change this 958778695 to a date

    Gary Lowe
    VB6 (Enterprise) SP5
    ADO 2.6
    SQL Server 7 SP3

    OK I know my spelling and grammer is crap so don't quote me on it!

    To err is human to take the P! is only natural !!

    Click on the top section of image for Marcus Miller website and bottom section of image for 'Run For Cover' sound clip

    Reply With Quote Reply With Quote
  2. Oct 27th, 2000, 09:48 AM #2
    SteveFlitIII
    SteveFlitIII is offline
    Lively Member
    Join Date
    Aug 1999
    Location
    Blackpool, England
    Posts
    87
    CDate will convert a date like expression into a date format, but I dont think it would change that number into a date.
    Reply With Quote Reply With Quote
  3. Oct 27th, 2000, 09:51 AM #3
    Gary.Lowe
    Gary.Lowe is offline

    Thread Starter
    Fanatic Member Gary.Lowe's Avatar
    Join Date
    May 2000
    Location
    In my sphere of influence
    Posts
    621
    This is in a text file and the documentation says it is the date/time the line in the file was written.

    As of yet I have not be able to determine how to convert it
    Gary Lowe
    VB6 (Enterprise) SP5
    ADO 2.6
    SQL Server 7 SP3

    OK I know my spelling and grammer is crap so don't quote me on it!

    To err is human to take the P! is only natural !!

    Click on the top section of image for Marcus Miller website and bottom section of image for 'Run For Cover' sound clip

    Reply With Quote Reply With Quote
  4. Oct 27th, 2000, 10:03 AM #4
    WP
    WP is offline
    Hyperactive Member WP's Avatar
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    278

    Wink Format

    You can use the Format function. But, there is a limit: 2958465 is the same as the 31 december of 9999. You can not go higher as this number.
    Code:
    Temp = Format("36826","dddd dd mmmm yyyy", vbMonday,  vbFirstJan1)
'Now, Temp will contain the date of today...
    Hope this helps you ,
    WP

    Visual Basic 6.0 EE SP5 / .Net
    Windows XP
    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