Date due calculation

[nickOS]

Can you recommend an easy way to add a number of days (say 10 days) to the current date to calculate a due date ?

Thanks

[mr_vodka]

Depends on how you want to use it. Get (CurrentDate) + 10 as an unstored calc will give the correct date.

[Robert Collins]

Do you already have a field that holds a current date (maybe a gobalfield set via startup script?

if so , create a calulation field called Duedate which would be:

Duedate = [your currentdatefield] +10

then set result to display as 'date'

or another way is

Duedate = Get(Currentdate) = 10

but there would be nothing to update that field , so after today it would show the wrong date

[Robert Collins]

sorry I meant:

Duedate = Get(Currentdate) + 10

[Anuviel]

or another way is

Duedate = Get(Currentdate) + 10

but there would be nothing to update that field , so after today it would show the wrong date

If unstored - it will update correctly.

It will always show a future date (todays date + 10 days)if unstored so it cannot be a due date as it will never come to pass.

Depending on your data and how you will be using it and for what it can be done in a couple of ways.

One would be:

Let's say you create an invoice. You set a InvoiceDate field as an auto-enter date on creation. That gives you obviously the date you created the invoice on. You then define "DueDate" field and set it to a calculation of InvoiceDate + 10 and the result is your Due Date.

with that setup if you create an invoice on 4.1.08 the due date would be 4.11.08.

[nickOS]

This is what I needed.

Thanks very much

[nickOS]

All, you have been very helpful, thanks