Skip to main content
J
jameli0507
April 11, 2023
Question

date value is not null

  • April 11, 2023
  • 4 replies
  • 0 views

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

S
sanchitg0002
April 11, 2023

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)
)

    U
    ujjwalr0002
    Participating Frequently
    April 11, 2023

    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)
)

    J
    jameli0507Author
    April 13, 2023

    Thank you for that

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    April 14, 2023

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

    Terms & ConditionsAccessibility statement