Add 15 days to a date column

[satz]

There is a column called Revenue plan (Date/Time) Format, which has a date.


I have a column called Billing Value, where I want result Revenue plan + 15 days ( I used calculated and added this same formula it says different data type)

Please help me to do this?

[CJ_London]

you need to clarify - what is the full error message? what is your code? From what you have provided so far I can only suggest using the dateadd function

[satz]

"Syntax error in expression" this is the error message.

[CJ_London]

you should not be storing this as a calculated field in a table, but calculate as required in a query

calculated fields are very limited in their use and in any event you cannot use things like the dateadd function here.

if you must, try

[RevenuePlan]+15

[satz]

[Revenue Plan] + 15 directly not working

[satz]

This is how it shows when i directly type [Revenue Plan] +15

[CJ_London]

a) you've changed the field name from billing due to billing value
b) you have not specified a result type
c) I don't use calculated fields, too limiting - but try putting an = before the formula
d) compare with what you have in the Expected delivery date field