Month and Year in Crystal 2008

[sap1958]

I have a formula as follows:

if month({PayrollDeduct.gifteffdat}) =
Month(currentdate)then 'New Pledge'

this says that if the gifteffdate month equals the currentdate month then New Pledge. I want to expand this and say that if the year is this year, show new pledge pledge. The current formula only considers the month.

 

[CoSpringsGuy]

if month({PayrollDeduct.gifteffdat}) =
Month(currentdate)
and
year({PayrollDeduct.gifteffdat}) =
year(currentdate)
then 'New Pledge'

unless you meant
if month({PayrollDeduct.gifteffdat}) =
Month(currentdate)
else if
year({PayrollDeduct.gifteffdat}) =
year(currentdate)
then 'new pledge pledge'

but i dont think so

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection