Dynamics 365 general forum

Adding a whole number to a date field

(0) Share

Report

Posted on by VICKIM

I have a date field in an entity and wish to add a whole number, "terms" to know the due date of an invoice.

1362.Capture.JPG

How do i do this.

Categories:

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

Adrian Begovich 1,027 Moderator on at

Like (0)

Report

Hi VICKIM,

You can use the ADDDAYS (whole number, date and time) function to return a new date and time that is equal to the given date and time, plus the specified number of days.

Was this reply helpful? Yes No
VICKIM 27 on at

Like (0)

Report

The issue i have is some vendor terms are different for each vendor. some are 7 days, others 14 days and others 30 days.

So i need to add either 7,14 or 30 to the vendor invoice date depending of the terms.

Was this reply helpful? Yes No
Verified answer

LuHao 40,892 on at

Like (1)

Report

Hi partner,

You still need to use the formula ADDDAYS(whole number, date and time).

The whole number can be a field, not necessarily a fixed number.

The following is an example:

"invoice date" is a field of type Date.

"sap terms" is a field of type Whole Number.



"invoice due date" is a calculated field of type Date. I set the calculation logic to ADDDAYS(new_sapterms,new_invoicedate).



The effect is as follows:



Was this reply helpful? Yes No
VICKIM 27 on at

Like (0)

Report

I tried above but no luck. Not sure if it is because data is stored in two different entities. The field i am trying to add "invoice due date" is located in entity "Invoice". The terms are located in the entity "vendor"

Was this reply helpful? Yes No
LuHao 40,892 on at

Like (0)

Report

Hi partner,

Based on the error message in your screenshot, your calculated field appears to be of text type, not Date type.

Please check the data type of your calculated field.

As in my last answer, it must be a Date type.

Was this reply helpful? Yes No
Suggested answer

VICKIM 27 on at

Like (0)

Report

Perfect. Thank you so much. Works a treat.

Was this reply helpful? Yes No
LuHao 40,892 on at

Like (0)

Report

Hi partner,

Don't forget to click Yes to mark the verified answer.

This will help other users quickly navigate to this theme.

Tnanks.

Was this reply helpful? Yes No
Tim_Hof 40 on at

Like (0)

Report

Are there any suggestions how to do this in a workflow?

I want to change 2 datefields in a workflow. Booking date I set to 'changed on', and due date I want to set to 'Changed on' + 'Due days'(integer field on the same entity). Recommendations for doing so?

Was this reply helpful? Yes No