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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

datediff?

Status
Not open for further replies.
nb4884

nb4884

IS-IT--Management
Aug 2, 2010
141
US
Hi All,

If I have dates like F = 04/05/2011 ans S as 09/24/2010 then datediff ("m", {S}, {F}) gives me 7 months but is there a way to get exact number like 6.3xx etc?

Thanks
 
Sort by date Sort by votes

Try changing the "m" to "d" to get the number of days, then divide by 30.4 to get the fractional months.

 
Upvote 0 Downvote
you would have to use a value other than months ("m") and then convert to get the decimal.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ms901Boss
  • Locked
  • Question
Crystal Report with DateDiff 1
Replies
5
Views
482
ms901Boss
ms901Boss
capronton
  • Locked
  • Question
DateDiff not calculating negative value 1
Replies
18
Views
220
SkipVought
S
jwaldner
  • Locked
  • Question
Datediff Questions
Replies
3
Views
85
jwaldner
jwaldner
DeviousDi
  • Locked
  • Question
Datediff when date held in one field?!
Replies
0
Views
54
DeviousDi
DeviousDi
records333
  • Locked
  • Question
DateADD, DateDiff, DatePart???
Replies
6
Views
83
records333
records333

Part and Inventory Search

Sponsor

Back
Top