Another Date Calc questions

[amypaulsmom]

I have a date field that I would like to be able have it auto-enter the requested date, but then I also need to be able to manually change the date as well, if required.

The field is currently a calculation field and I know I can't enter the info in that form.

But - if I change the field to a Date field and then have it do a calculated result - it gives me a blank field.

The field I am working with is Date Due, which is currently the Invoice Date +30. When I change Date Due to a date field and set the calculated result to Invoice Date + 30 it just stares blankly back at me.

I have some other fields which work fine - that are date fields as well. Date Due 1(date field pulling from calculated result) = Date Due +30.

This gives me the wanted result and the ability to edit the field if necessary. That is what I need for the Date Due field.

Ideas?

Thanks.

[danjacoby]

When you create a non-calc field and set an auto-enter, it only works once -- when the record is created.

Better idea: Keep the DueDate field as a calc field, but add another Date field ("ManualDueDate"). Have the DueDate calc read:

If(isEmpty(ManualDueDate), InvoiceDate + 30, ManualDueDate)

Now put the ManualDueDate field directly UNDER the DueDate field, and disallow entry in the DueDate field. When you click on it, since DueDate can't be entered, you'll go directly through to ManualDueDate.