DateDiff

J

jacqueline

I am calculating the difference between dates, I first
calculate
days : datediff ("d", date1, date2) It gives me 48 days.
months: datediff("m", date1, date2) It gives me 2 months.
Should that say 1 month instead of two?
86 days gives me 3 months or 21 days gives me 1 month


jackie
..
 
D

Duane Hookom

Most DateDiff() usage reports the number of "boundaries" that are crossed
betwee two dates.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DATEDIFF 3
averaging date fields 2
Date Difference Exclude Weekends 2
Month Counter 2
How do I find difference in MONTH for two DataTime 5
DateDiff Null Previous Date 3
Do...Loop not working 1
Age function how to 3

Top