Results 1 to 6 of 6

Thread: extracting hours,min and sec from system time

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Jan 2002
    Posts
    22

    Question extracting hours,min and sec from system time

    hi,

    i needed to extract the current hours, min and sec from the system time and store it in 3 variables - h, m and s. but i am unable to extract the min. hour and sec can be extracted correctly. i am using this code. could you kindly point out as to where i'm going wrong --


    h = Format(Time, "HH")
    m = Format(Time, "MM")
    s = Format(Time, "SS")

    m is always displayed as 12.

    thanks.

  2. #2
    PowerPoster beachbum's Avatar
    Join Date
    Jul 2001
    Location
    Wollongong, NSW, Australia
    Posts
    2,274
    Hi
    M is used for months.. use N for minutes.
    regards
    Stuart Laidlaw
    Brightspark Financial Software
    http://www.gstsmartbook.com

  3. #3
    -= B u g S l a y e r =- peet's Avatar
    Join Date
    Aug 2000
    Posts
    9,629
    Format(Time, "NN")
    -= a peet post =-

  4. #4
    -= B u g S l a y e r =- peet's Avatar
    Join Date
    Aug 2000
    Posts
    9,629
    what are u doing outside the world of CC Stuart ??
    -= a peet post =-

  5. #5
    PowerPoster beachbum's Avatar
    Join Date
    Jul 2001
    Location
    Wollongong, NSW, Australia
    Posts
    2,274
    Not enough people to harrass right now Peet nah.. am getting off here now.. just popped on for a quick look see.
    have a nice weekend
    Stuart Laidlaw
    Brightspark Financial Software
    http://www.gstsmartbook.com

  6. #6
    -= B u g S l a y e r =- peet's Avatar
    Join Date
    Aug 2000
    Posts
    9,629
    u to have a good one ...at the beach I presume
    -= a peet post =-

Posting Permissions

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



Click Here to Expand Forum to Full Width