Forum Discussion

Resolver I

7 years ago

Solved

Returning text based on difference

Hi All, Is there a way of returning text based on a number that I have got e.g. the difference between date(s)? e.g. Date 1 Date 2 Date Difference Text 01/01/2019 01/06/2019 151 ...

Need Help

evandrocunico
7 years ago
Hi UK_User123456

create a column:

date diference = DATEDIFF(date1;date2;DAY) (use semicolon or comma)

create another column:
text result = If (date diference <= 50;"New";date diference <= 150;"Existing";"Old")

best regards.

UK_User123456

Resolver I

7 years ago

jdbuchanan71see below the screenshots. The data types should are the same, as there are no true/false.

I wanted to be able to say that if the "Date Difference is between a certain number it would return the text I wanted it to display. I have also attached the error message that I receive.