Announcements
cancel
Showing results for
Did you mean:
Creator III

## If condition issue

Hi,

I have used the below if condtion.

if(num([Calendar Date]) - num([Start Date])<=30, '0 TO 30 DAYS',

if(num([Calendar Date]) - num([Start Date])<=60, '31 TO 60 DAYS',

if(num([Calendar Date]) - num([Start Date])<=75, '61 TO 75 DAYS',

if(num([Calendar Date]) - num([Start Date])<=90, '76 TO 90 DAYS',

if(num([Calendar Date]) - num([Start Date])<=180, '91 TO 180 DAYS',

if(num([Calendar Date]) - num([Start Date])<=365, '181 TO 365 DAYS',

if(num([Calendar Date]) - num([Start Date])> 365,'>365 DAYS','UNKNOWN'))))))),'NOT APPLICABLE'

But i'm getting only NOT APPLICABLE.

Please let me know the right one.

Thanks..

1 Solution

Accepted Solutions

Remove NOT APPLICABLE and Test?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
4 Replies
Partner - Contributor III

Remove NOT APPLICABLE and Test?