I am updating a database and most of the invoicing features. I want the Date Due field to give me the Invoice Date + 30. This works if I do Status(Current Date) + 30. But - why can't I use the Invoice Date field + 30. When I do this - I just get a question mark.

Thanks for your advice. This seems like a simple question - I am hoping there is a simple answer.

The question mark just means that the result of your calculation won't fit in the field size you have defined on your layout. Make sure that both the Invoice Data field and the field that is the result of your calculation are defined to have the type Date.

-bd

Make sure you InvoiceDate field is actually defined as a date field and not, for instance, a text field.

Chuck

It is a date field. I have found another way for the time being.

Thanks-

Back to this question -

I am no longer getting a question mark - but nothing.

I can get the function to work - if I use the status(current date) function. But - this will change the due date everyday. Not what I want to happen.

Anyother suggestions of how I can get the Due Date to be the Invoice Date(creation date) +30?

thanks

This should work

Invoice date (Date field)

Due Date (calc result set to date) Invoice Date + 30

Check your field types!

Hi -

Thanks for the advice - but that is how I have it and it is staring blankly back at me.

Very strange.

created a sample in FM here, with 1 date field and one calculated date field and works perfectly.

Can send a sample!