Hi Kenny,
The NOTEMPTY does not seem to me as a likely option as it fails provisioning when the value is empty, and that is no different from now, which fails provisioning due to an incorrect format for the date.
The FIRSTOF is taking the first value, in my case i am creating the entire date from its value, so:
for example:
FIRSTOF(%UCU06:5,4%-%UCU06:3,2%-%UCU06:1,2%,'')
this will create the first value as '--' and that is not blank so it will be set and fail provisioning.
have i understood it incorrectly?
Thanks
Abinash