Results 1 to 2 of 2

Thread: Subtract Date

  1. Feb 1st, 2000, 05:17 PM #1
    SAMS
    SAMS is offline

    Thread Starter
    Member
    Join Date
    Aug 1999
    Location
    Singapore
    Posts
    43

    Post

    Hi guys,
    How do i subtract two date in two text box. Thks

    Error when:
    val(text1.text) -val(text2.text)
    Reply With Quote Reply With Quote
  2. Feb 1st, 2000, 07:57 PM #2
    Mark Sreeves
    Mark Sreeves is offline
    Frenzied Member Mark Sreeves's Avatar
    Join Date
    Nov 1999
    Location
    UK
    Posts
    1,845

    Post

    use datediff:

    Text3 = DateDiff("d", DateValue(Text1), DateValue(Text2))

    ------------------
    Mark Sreeves
    Analyst Programmer

    [email protected]
    A BMW Group Company


    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