First day of the month following a date

[Extrmdressage]

I need a formula for Crystal for the first of the month following a date. For example, if a date is 12/27/09, the formula would need to return 01/01/10. I have tried several formulas, but keep getting errors. Any assistance would be appreciated. Thanks in advance.

 

[CoSpringsGuy]

if month({@date}) = 12 then
date(year({@date})+1,1,1)
else
date(year({@date}),month({@date})+1,1)

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

 

[lbass]

Or, you could use:

dateserial(year({table.date}), month({table.date})+1, 1)

-LB

 

[CoSpringsGuy]

lbass solution is better .... I tried to do that with date() but got an error obviously...

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