Help!
I have two fields, one contains a date, the other contains a frequency. Based on this I want to have a third field populated with the date of the next occurrence.
the first IF statement works and correctly sets the date, the second is ignored and no error. It just does not populate the field at all.
I am using the following:
IF(Recurrence = “Weekly”,DATEADD({Invoice Due Date},7,‘Days’,
IF(Recurrence = “Monthly”,DATEADD({Invoice Due Date},1,‘Month’))))
You’re missing a closed parentheses after your first DATEADD() function. :slightly_smiling_face:
Try this…
IF({Recurrence} = "Weekly", DATEADD({Invoice Due Date}, 7, 'day'), IF({Recurrence} = "Monthly", DATEADD({Invoice Due Date}, 1, 'month')))You’re missing a closed parentheses after your first DATEADD() function. :slightly_smiling_face:
Try this…
IF({Recurrence} = "Weekly", DATEADD({Invoice Due Date}, 7, 'day'), IF({Recurrence} = "Monthly", DATEADD({Invoice Due Date}, 1, 'month')))Thank you! Not sure how I missed that but working good now :slightly_smiling_face:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.