Calculating Date Differences

Results 1 to 3 of 3

Thread: Calculating Date Differences

  1. #1
    shaz Guest

    Default Calculating Date Differences

    Please helm me, does anyone know how to calculate the difference between 2 date fields with now() values? Much appreciated.

  2. #2
    Join Date
    Dec 1969

    Default RE: Calculating Date Differences

    hello,<BR>i&#039m a beginner, but i used this function from help files and it works for me.<BR>Function DiffADate(theDate)<BR>DiffADate = DateDiff("d", Now, theDate)<BR>End Function<BR>&#039 n - min, h - hours<BR>hope this helps<BR>lana<BR>

  3. #3
    shaz Guest

    Default RE: Calculating Date Differences

    Thank you for responding so quickly, however, I do not think that I explained the situation very clear. I have 2 date fields containing the format for now() eg, 16/02/00 21:32:14 and I&#039d like to know how to calculate the differences between these 2 fields. Is this possible? Thanks

Posting Permissions

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