Action profile: condition "is empty"

[anais_jaussaud]

Dear Experts,

I am trying to configure action profile with the following condition:

' Date REL1 = EMPTY '

Indeed, i want the action to be executed when the specific date is empty.

I cannot find any condition 'empty' in the contener.

Is there any solution?

Thanks a lot for your help,

Regards,

Anaïs

[Former Member · Accepted solution]

Hi Anais

Have you tried with NE ''.

If that does work try NE '00000000'.

Regards

Arden

[anais_jaussaud · Accepted solution]

Hi Arden, it does not work either.

If I try to enter constant '00000000' I have got a warning saying " Constant invalid : Object reference expected cannot be converted to Date Format.

Thanks anyway.

All other solution will be more than welcomed

Regards,

Anaïs

[Former Member · Accepted solution]

Hi Anais

Is there any other Date Field that you know will always left unpopulated. If so you could use that as the condition check: &PCD NE DATEFIELDXYZ

Regards

Arden

[anais_jaussaud · Accepted solution]

Hi Arden,

Thanks for your reply. Unfortunately, I come across a new error : "Constant Invalid / String lenght 12 is not between 5 and 10"

Any other solutions?

thanks a lot,

Regards,

Anaïs

[Former Member · Accepted solution]

Hi Anais

When I typed DATEFIELDXYZ I was meaning an existing Date Field available to you.

So something like Z_DATE_NPCJ3....but...If I was you I'd add another Date Type to the Date Profile and call it Z_DATE_NPCBLANK.

Ensure that the value is never populated.

Then your condition becomes &PCD NE Z_DATE_NPCBLANK

Make Sense?

Regards

Arden

[anais_jaussaud · Accepted solution]

Sorry for the late reply Arden.

Well, we still did not find a solution. I am going to populate the date with a date like 31.12.9999 until it is filled by the user. And my action profile will be based on this date...

Thanks anyway

regards,

Anaïs

[Former Member · Accepted solution]

Anaïs,

You can also try using the EX en NEX as operators.

In your case, I guess NEX might do the trick.

Regards,

Pieter

[anais_jaussaud · Accepted solution]

Thanks a lot Pieter, it is indeed the operator to use.

Obviously, that's the only one I did not checked...

Thanks for your help,

Regards,

Anaïs

[Maggie]

Hi Anais,

If you leave the constant as empty, you will create an condition with empty criteria.

Best regards,

Maggie

[anais_jaussaud]

Hi Maggie,

thanks for your reply. I have tried the following but is does not work. the action is not executed.

Is it the action on the date that does not work as it does work with only the status condition.

Thanks anyway,

Regards,

Anaïs