Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Help with date forumula Post Reply Post New Topic
Author Message
ChrisJ517
Newbie
Newbie


Joined: 21 May 2007
Online Status: Offline
Posts: 16
Quote ChrisJ517 Replybullet Topic: Help with date forumula
    Posted: 30 Apr 2008 at 8:26am
I have a field that shows the invoice date (inv_date) and I need to go 15 months from that date using a formula.  I know how to add days, but is there a way for months?  (adding days doesn't work right since there are some months with more days than others)
IP IP Logged
ChrisJ517
Newbie
Newbie


Joined: 21 May 2007
Online Status: Offline
Posts: 16
Quote ChrisJ517 Replybullet Posted: 30 Apr 2008 at 1:12pm
Anyone?
IP IP Logged
andymc
Newbie
Newbie
Avatar

Joined: 17 Mar 2008
Location: United States
Online Status: Offline
Posts: 18
Quote andymc Replybullet Posted: 30 Apr 2008 at 1:17pm
DateAdd ("m", 15, {inv_date})
m is for months
q is for quarters
d is for days
yyyy is for years
Andymc
IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.016 seconds.