Date Calculation

[Dianne]

I am trying to have a date field with a date and then another date field with the date 30 days after the first date? I can't figure it out - Any ideas would be greatly received.

[Fitch]

Date + 30

[Dianne]

bascially I am trying to set an invoice due date which is 30 days from the date of invoice.

(Invoice date) + 30 doesn't work for obvious reasons

I have tried a few different formulas including...

& Date(Month(Invoice date) + 1;Day(Invoice date);Year(invoice date))

I can't figure it out - can anybody shed shoe light?

Thanks in advance

[Dianne]

bascially I am trying to set an invoice due date which is 30 days from the date of invoice.

(Invoice date) + 30 doesn't work for obvious reasons

I have tried a few different formulas including...

& Date(Month(Invoice date) + 1;Day(Invoice date);Year(invoice date))

I can't figure it out - can anybody shed shoe light?

Thanks in advance

[Dianne]

bascially I am trying to set an invoice due date which is 30 days from the date of invoice.

(Invoice date) + 30 doesn't work for obvious reasons

I have tried a few different formulas including...

& Date(Month(Invoice date) + 1;Day(Invoice date);Year(invoice date))

I can't figure it out - can anybody shed shoe light?

Thanks in advance

[electrobase]

I'm sorry, why doesn't invoice date + 30 work? we have been using just that formula for years.

good luck!

:-)

[electrobase]

I'm sorry, why doesn't invoice date + 30 work? we have been using just that formula for years.

good luck!

:-)

[electrobase]

I'm sorry, why doesn't invoice date + 30 work? we have been using just that formula for years.

good luck!

:-)

[Dianne]

it does - sorry!! had invoice date set to number rather than date. (invoice date) + 30 was the first thing I tried and when I corrected that it didn't occur to me to try again...thanks so much for replying.

[Dianne]

it does - sorry!! had invoice date set to number rather than date. (invoice date) + 30 was the first thing I tried and when I corrected that it didn't occur to me to try again...thanks so much for replying.

[Dianne]

it does - sorry!! had invoice date set to number rather than date. (invoice date) + 30 was the first thing I tried and when I corrected that it didn't occur to me to try again...thanks so much for replying.

[Dianne]

any idea how to get it to ignore weekends?

[Dianne]

any idea how to get it to ignore weekends?

[Dianne]

any idea how to get it to ignore weekends?

[-Queue-]

invoice date + 30 + 2 * (DayOfWeek(invoice date) = 5) + (DayOfWeek(invoice date) = 6)

This will give any invoices from Thursday or Friday the same due date of the following Monday after invoice date + 30.

[-Queue-]

invoice date + 30 + 2 * (DayOfWeek(invoice date) = 5) + (DayOfWeek(invoice date) = 6)

This will give any invoices from Thursday or Friday the same due date of the following Monday after invoice date + 30.

[-Queue-]

invoice date + 30 + 2 * (DayOfWeek(invoice date) = 5) + (DayOfWeek(invoice date) = 6)

This will give any invoices from Thursday or Friday the same due date of the following Monday after invoice date + 30.