Dates 1

[scon165]

I have a date field that shows the exact date the service was performed, but on my report when it displays they only want it to display back to the first of whatever month it is in. Is there a formula that will convert it for me? Example if the date shows 09/15/2003 I want it to display 09/01/2003.

Thanks
Sharon

 

[synapsevampire]

Try:

cdate(year({table.datefield}),month({table.datefield}),1)

or try:

{table.datefield}-(day({table.datefield})-1)

-k