Skip to main content
New Participant
Apr 11, 2023 11:05 AM UTC
Question

date value is not null

I'm making an interface form with Appian. I'm making the form interactive. A textbox should only appear when specific variables are true. Appian offers a wonderful feature for this where you can add an expression to a "only show when" function.

It presently holds the following expression:

edate(today(), -804) >= ri!GeboorteDatum

The variable on the form is ri!geboortedatum.

Another statement that says: only show when the date value is not null is required. I tried everything but nothing worked. Is there a solution? The programming language appears to be similar to Microsoft Excel.

Perhaps something like

edate(today(), -804) >= ri!GeboorteDatum & isnull(ri!Geboortedatum)

4 replies

sanchitg0002
Inspiring
Apr 11, 2023 11:17 AM UTC

You can wrap both expressions in and()

I think you will be needing not null function instead of isnull()

like: 

and(
  edate(today(), - 804) >= ri!GeboorteDatum,
  a!isNotNullOrEmpty(ri!Geboortedatum)
)

Participating Frequently
Apr 11, 2023 11:24 AM UTC

Hi, to check values are not null you can use isNotNullOrEmpty

Try to use the below code in your show when condition 

and(
  edate(today(), - 804) >= ri!GeboorteDatum,
  a!isNotNullOrEmpty(ri!GeboorteDatum)
)

New Participant
Apr 13, 2023 8:50 PM UTC

Thank you for that

stefanhelzle0001
Brainy
Apr 14, 2023 5:59 AM UTC

The ampersand character "&" is used to concatenate strings in Appian. Use the functions and() or or() to build logical expressions.