MS Access: How to add 15 days to date (data type) in Access Web App

Question

My question is simple, How do I add 15 days to a "Field with Data type (Date/Time)" in Access Web App.

There is a Field called Revenue Plan which is a 'Date/Time' Data Type. and in Billing Due I selected data type 'Calculated' and typed formula mentioned below

Tried :

[RevenuePlan] + 15 //didn't Work//
DateAdd("d",15,[Revenue Plan]) //didn't work//

these both didn't work. Please help me out with this.

Note: Its for Access Web App

Thanks, Satish

score 3 · Accepted Answer · answered Jul 08 '16 at 13:36

3

The syntax is slightly different for an Access Web App for the DateAdd function.

The correct syntax should be

=DateAdd(Day,15,[Revenue Plan])

Here is the relevant MSDN link:

MSDN Link

answered Jul 08 '16 at 13:36

random_answer_guy

856
4
11

Thanks buddy for your reply :) I got the result. – Satish Jul 11 '16 at 05:18

score -1 · Answer 2 · answered Aug 17 '16 at 10:39

-1

Hello I could find the answer, Its below.

=DateAdd(Day,15,[Revenue Plan])

answered Aug 17 '16 at 10:39

Satish

23
7

MS Access: How to add 15 days to date (data type) in Access Web App

2 Answers2