Sunday, March 25, 2012

Crystal Rpt 10 - currentdate + 6 months

Hey all I am trying to use Crystal Reports 10 and have a date that I need to use from my table. I want to take that date and if it is greater than the CURRENTDATE + 6 months I need to display a message. I have part of it but not sure how to do the "6 month" thing.

if ({mytable.mydate}) > CurrentDate ("+6 months") then
'Length-Promo-Rate = 0'

I have tried this:
CurrentDate + Month({mytable.mydate},6) but it doesn't like it. Suggestions? Thanks.Hi,
for that you have to insert a formula field like :

dim msg as string
if {Report Date/date from table} >= DateAdd ("m",6 , CurrentDate) then
msg ="6 month old"
else
msg = "new"

end if

formula = msg

-Jayesh Mendpara

No comments:

Post a Comment