Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Count No. of months between dates

Status
Not open for further replies.
Sukh007

Sukh007

Technical User
Joined
Jul 24, 2008
Messages
16
Location
GB
Hi Guys

I have 2 date fields A1 & A2. How can I calculate the number of months between the 2 data fields?

Thanks
 
Sort by date Sort by votes
Hi Guys

Found the answer

DateDiff ("m",{CONTACT2.UA1},{CONTACT2.UA2}).
 
Upvote 0 Downvote
Note that datediff just subtacts the month value in each field, so that the difference between date(2008,8,31) and date(2008,9,1) (one day) would return a result of one month. You might be better off using:

datediff("d",{CONTACT2.UA1},{CONTACT2.UA2})/30

-LB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

B
  • Locked
  • Question Question
Difference of a field between 2 variable dates
Replies
1
Views
614
hilfy
hilfy
inkbird01
  • Locked
  • Question Question
Filters > Record Selection for dates between
Replies
4
Views
850
pmax9999
pmax9999
cursedkorok
  • Locked
  • Question Question
Group consecutive dates
Replies
12
Views
1K
pmax9999
pmax9999
Corinne30
  • Locked
  • Question Question
Division of currency formula with/without rounding
Replies
7
Views
1K
dgillz
dgillz
tlbrown88
  • Locked
  • Question Question
How does one get the results of a Calculation (SharedVar) on the same line as the Sub Report?
Replies
4
Views
959
tlbrown88
tlbrown88

Part and Inventory Search

Sponsor

Back
Top