Forum Discussion
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 ...
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.
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.
evandrocunico many thanks, will try this out. I have created a new column already for date diff and this throws out some random numbers, but I think I know where the issue lies.
I will respond once I have had the chance to try it out.