Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Calculate date (date + 1 year) Post Reply Post New Topic
Author Message
gnaus
Newbie
Newbie
Avatar

Joined: 13 Sep 2011
Location: Netherlands
Online Status: Offline
Posts: 14
Quote gnaus Replybullet Topic: Calculate date (date + 1 year)
    Posted: 06 Mar 2015 at 2:00am
dear people,
 
I want to calculate a new date. Starting with an existing date, {ActieveMdwsNoodzakelijkeCursussen.Examendatum}.
I just want a result: Examendatum + 1 Year.
 
How can I do that in my formula in a report?
 
My formula sounds , so far, like this:
 
If {ActieveMdwsNoodzakelijkeCursussen.Herhalingsinterval}='12' then {ActieveMdwsNoodzakelijkeCursussen.Examendatum} 
 
but I don't want {ActieveMdwsNoodzakelijkeCursussen.Examendatum} as a result but I want {ActieveMdwsNoodzakelijkeCursussen.Examendatum} + 1 year as a result
 
thank you very much!
 
Crystal Reports XI
GN
IP IP Logged
gnaus
Newbie
Newbie
Avatar

Joined: 13 Sep 2011
Location: Netherlands
Online Status: Offline
Posts: 14
Quote gnaus Replybullet Posted: 06 Mar 2015 at 4:02am
Found it already...
thanks anyway
gr GN
 

If{ActieveMdwsNoodzakelijkeCursussen.Herhalingsinterval}='12' then DateAdd("yyyy", 1, Date({ActieveMdwsNoodzakelijkeCursussen.Examendatum})) else

If{ActieveMdwsNoodzakelijkeCursussen.Herhalingsinterval}='24' then DateAdd("yyyy", 2, Date({ActieveMdwsNoodzakelijkeCursussen.Examendatum}))

GN
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.031 seconds.