replace datefrom WITH GOMONTH(loData.dLastBillDate+1, -1)> 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}.