Hi All,

I have a table that holds a date, I have to fill that date from a text file which I put into a variable before hitting this code.

loData.dLastBillDate = ctod("04/30/2006")

replace datefrom WITH GOMONTH(loData.dLastBillDate, -1) + 1

this gives me a blank datefrom field, because GOMONTH() evaluates to {03/31/2006}, it should come up with {04/01/2006}.

I need this to work in all cases, not just 11 out of 12. Can anyone help me?

TIA
Beth