Results 1 to 3 of 3

Thread: DataDiff

  1. Mar 20th, 2000, 08:35 PM #1
    VBAmateur
    VBAmateur is offline

    Thread Starter
    Lively Member
    Join Date
    Jan 2000
    Location
    Greenville
    Posts
    73
    Hello I am trying to find the number of days in between 2 dates and when I use the following code it does not work right all the time. The problem I believe is when I subtract dates from 2 different YEARS. Does anyone have any suggestions on this....

    txt1.text = DateDiff("d", txt2.text, Date)
    Reply With Quote Reply With Quote
  2. Mar 20th, 2000, 09:10 PM #2
    bsmith
    bsmith is offline
    Lively Member
    Join Date
    Jan 2000
    Location
    Springfield, IL
    Posts
    124
    Does txt2.Text need to be converted to a date variable or is it not formatted properly? It seemed to work all right for me in VB6.
    Reply With Quote Reply With Quote
  3. Mar 20th, 2000, 10:52 PM #3
    OneSource
    OneSource is offline
    Fanatic Member
    Join Date
    Jan 2000
    Location
    Mobile, AL, USA
    Posts
    600

    Examples

    Hi VBAmateur,

    I'm with bsmith, I ran it on VB6 without any problems. It will be a lot easier to help you if you provide example dates that are giving you trouble.

    All the best.
    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