Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Simple Formula Question for Someone Post Reply Post New Topic
Author Message
mparish
Newbie
Newbie


Joined: 20 Aug 2008
Location: United States
Online Status: Offline
Posts: 9
Quote mparish Replybullet Topic: Simple Formula Question for Someone
     Posted: 16 Feb 2009 at 12:58pm

In regard to a date/time field, I am trying to set up a formula that will calculate the difference between the current date (month and year) and a date/time field (month and year only) on an invoice.

For example, I need Crystal to calculate the number of months between February 2009 and October 2007.
 
Thanks!
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 16 Feb 2009 at 1:40pm
looking in 'Functions' section of the formula editor under date and Time...DateDiff("m", startdate, enddate)
 
Hope it helps.
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum