Newbie Questions

Re: Add Days to date based on value in another field

Hilary Stoupa — Fri, 08 Nov 2019 16:16:24 GMT

Is this a list form? The type of column comes into play here. I'd assume the result of the addDays formula would be a date time?

Re: Add Days to date based on value in another field

Ruenells — Fri, 08 Nov 2019 16:05:49 GMT

I am having an issues with adding dates I can get this to work addDays(equiporderbked, 180) however, when I try to submit the form in Sharepoint it says it can only be an integer. I change it to integer and republish same issue, change to string same thing. What am i missing to get this to work?

Re: Add Days to date based on value in another field

Hilary Stoupa — Wed, 06 May 2015 14:40:11 GMT

Aren't those backwards in the formula? https://support.office.com/en-gb/article/Add-days-to-a-date-fe3d1c01-2409-43f1-bfc4-8d7f953247a6?ui=en-US&rs=en-GB&ad=GB&fromAR=1

I think you want addDays(today(), Reminder).

Re: Add Days to date based on value in another field

TCI2013 — Mon, 04 May 2015 05:39:15 GMT

Did you ever resolve this issue? I'm having the same problem. I am using a text field however [Reminder], type is number, no decimals. The formula shows no errors, addDays(Reminder, today()), but when I test the form, the resulting date field shows an error when I set a 'Reminder' number.

Re: Add Days to date based on value in another field

donstephen — Tue, 07 Oct 2014 09:53:52 GMT

Hi d24n4e,

Your formula is correct. using addDays(Quote Received Date, Daysfield) should work for adding or subtracting dates. Is your date picker's data type format set to date and time? Please try changing the format to date only or text and see if that works. If not, kindly attach a sample of your form so I could get a clearer idea of what isn't working for you.

Regards,

Add Days to date based on value in another field

d24n4e — Tue, 30 Sep 2014 12:03:13 GMT

Good afternoon,

I am trying to add days to an expiry date field based on a variable value in a field that is a look up to a secondary data source i.e. it may be 30 days or 60 days depending on the content of another field. However, I get ERR? in the date field. If I just use the formula addDays(Quote Received Date, 30) then it works fine, but how can I get it work with the formula addDays(Quote Received Date, Daysfield) rather than defining the number of days? The value to be added will definitely vary due to the criteria within the form, which is why I have set up rules to correctly populate the number of days to be added in the Days field.

I would be so grateful if anyone can please help!!

Thanks