Calculation using two functions

[Richard Legault]

Hi,

I’m new user and I’m trying to do a calculation using two functions: YYMMDD and IFNOTEMPTY

IFNOTEMPTY(date;(YYMMDD(date;TODAY() )))

so if date not empty will return in text = year(s), day(s) and month(s)

Date = Oct 6, 2018
Today = Oct 14, 2019

should return : 1 year, 0 months, 7 days

Nothing is return.

What I’m doing wrong ?

Thank

[Daniel Leu]

Did you set the return type to ‘text’?

IFNOTEMPTY expects three arguments and you are only providing two:IFNOTEMPTY(Date;YYMMDD(Date;TODAY());"empty")

[john cesta]

Kinda like but the opposite….

IFEMPTY([DateApptSET];DAYS([Date Created];TODAY());”contact made”)

Searching on if not empty will turn up lots of help on this function

[Sam Moffatt]

IFNOTEMPTY has three arguments per the Calculations manual page.

Looking at your calculation:
IFNOTEMPTY(date;(YYMMDD(date;TODAY())))

I think maybe you’re missing a bracket after the second instance of date?

IFNOTEMPTY(date; YYMMDD(date); TODAY())

If it’s not empty, print the YYMMDD of date or use TODAY().

The default output of a calculation field is number, try flipping it to text as well in case you don’t get any output. Text will accept almost any output type but it does change what formatting options work (hence the other two options).

[Richard Legault]

@daniel tanks you nailed it.

Thanks everybody for your help ;-)

[Author]

Posts