Results 1 to 5 of 5

Thread: Configuring datevalues

  1. Jul 4th, 2003, 08:54 AM #1
    holly
    holly is offline

    Thread Starter
    Fanatic Member holly's Avatar
    Join Date
    Aug 2002
    Location
    Somewhere on earth
    Posts
    721

    Configuring datevalues

    Hi

    I have a lbl on my form which shows todays date but
    I need to configure this date....

    I need the date to register as yesterdays date until 06.30am........

    I know I cound probably use dateadd etc but I need something that will deduct the date until 06.30am and then show todays date..............Does anyone know of anything that could
    accomplish this??

    Hope I have made myself clear!!!!

    Thanks
    ** HOLLY **
    Reply With Quote Reply With Quote
  2. Jul 4th, 2003, 09:43 AM #2
    FATBOYPEE
    FATBOYPEE is offline
    Hyperactive Member FATBOYPEE's Avatar
    Join Date
    May 2001
    Location
    Charleville (Ireland) Still. ANYONE GOT A JOB I CAN HAVE ? GIZA JOB. I CAN DO THAT....
    Posts
    463
    yep. Clear as mud....

    Best Bar.....
    Reply With Quote Reply With Quote
  3. Jul 4th, 2003, 09:43 AM #3
    FATBOYPEE
    FATBOYPEE is offline
    Hyperactive Member FATBOYPEE's Avatar
    Join Date
    May 2001
    Location
    Charleville (Ireland) Still. ANYONE GOT A JOB I CAN HAVE ? GIZA JOB. I CAN DO THAT....
    Posts
    463
    yep. Clear as mud....

    Best Bar.....
    Reply With Quote Reply With Quote
  4. Jul 4th, 2003, 09:47 AM #4
    FATBOYPEE
    FATBOYPEE is offline
    Hyperactive Member FATBOYPEE's Avatar
    Join Date
    May 2001
    Location
    Charleville (Ireland) Still. ANYONE GOT A JOB I CAN HAVE ? GIZA JOB. I CAN DO THAT....
    Posts
    463
    VB Code:
    1. If Time < "06:30:00" Then

    2.  
    3.   Label1.Caption = (Format(Now - 1, "dd/mm/YYYY"))

    4.   

    5. Else

    6.  
    7.   Label1.Caption = (Format(Now, "dd/mm/YYYY"))

    8.   

    9. End If



    Best Bar.....
    Reply With Quote Reply With Quote
  6. Jul 4th, 2003, 10:17 AM #5
    holly
    holly is offline

    Thread Starter
    Fanatic Member holly's Avatar
    Join Date
    Aug 2002
    Location
    Somewhere on earth
    Posts
    721
    Thanks Fatboypee...I will give it a try

    Was it as clear as mud....

    Thanks for your help
    ** HOLLY **
    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