Create first of the month date from date field

[UHsoccer]

I am using Crystal 8.5 and need a formula to create a date that always displays the first of that month date, such as:

field name is {forecast.CloseDate}

9/25/2004 -> 9/1/2004
12/16/2005 -> 12/1/2005

etc

Thanks in advance

 

[lbass]

You could use:

{forecast.CloseDate}-day({forecast.CloseDate})+1

-LB

 

[UHsoccer]

Thanks, added to my report, but have trouble connecting to the data base.

Will let you know in the morning.

Thanks