Results 1 to 3 of 3

Thread: DateDiff

  1. #1
    Join Date
    Dec 1969

    Default DateDiff

    What is the syntax for finding out the difference between 2 dates using DateDiff and if the 2 dates are stored in variables.<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: DateDiff

    If you want to find the difference between 1/1/00 and currentdate <BR>Dim Mydate<BR>Mydate="1/1/2000"<BR>For the month<BR>Datediff("m",Mydate,Date)<BR>In this the result will be 3 months.<BR>For the year<BR>Datediff("yyyy",Mydate,Date)<BR>For the day<BR>Datediff("d",Mydate,Date)<BR><BR><BR>

  3. #3
    prem Guest

    Default RE: DateDiff

    give me your email.i can help me out.

Posting Permissions

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