Archer GRC: Calculate number days between two date fields

Question

When my values list Respondent Status changes to “Completed” I need to Calculate the number days between Date Initiated (date field) and Respondent Status Date Change (date field).

IF([Respondent Status ] = VALUEOF("Completed"),
DATEDIF([Date Initiated ], [Respondent Status Date Change], DAY),

How do I account for it the value isn't Completed? Something with true or false statements?

Alex Hollis · Accepted Answer · 2016-04-21T14:59:47.760

1

You can reference the field itself (and it will retain the current value) or a static value.

IF([Respondent Status] = VALUEOF([Respondent Status],"Completed"),
DATEDIF([Date Initiated], [Respondent Status Date Change], DAY),
[FIELD])

IF([Respondent Status] = VALUEOF([Respondent Status],"Completed"),
DATEDIF([Date Initiated], [Respondent Status Date Change], DAY),
0)

edited Apr 21 '16 at 14:59

answered Apr 21 '16 at 13:05

Alex Hollis

98
10

I took out the name of the field part to get my answer, I didn't need it in my calculation I've found. I'll edit yours and accept it. – PokéDev Apr 21 '16 at 14:28
DIdn't see those VALUEOF nice spot! – Alex Hollis Apr 21 '16 at 14:58

Archer GRC: Calculate number days between two date fields

1 Answers1