Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have this expression that is working exactly as I want while it is in a text box. However, when I define the expression as a variable it stops working! Do you have any idea why?
=if(GetFieldSelections(OrdItemInsDt)>0,
(if(GetFieldSelections(OrdItemInsDt)<7,
date(min(OrdItemInsDt))& ' to ' & date(max(OrdItemInsDt)),
(if(Left(GetFieldSelections(OrdItemInsDt),3) = '',
max({<Year-={$(=SubField(GetFieldSelections(OrdItemInsDt),'',2))}>} OrdItemInsDt),
date(min(OrdItemInsDt)))& ' to ' & if(Left(GetFieldSelections(OrdItemInsDt),3) = '',
max({<Year-={$(=SubField(GetFieldSelections(OrdItemInsDt),'',2))}>} OrdItemInsDt),
date(max(OrdItemInsDt)))))),
$(vLastInsDtWeek))
Thank You!
Hi,
It could be an issue around using "=" in the variable definition window and using/not using the $ expansion in your expression window. Could you confirm how you are initiating the expression?
thanks,
Micha
Hi,
It could be an issue around using "=" in the variable definition window and using/not using the $ expansion in your expression window. Could you confirm how you are initiating the expression?
thanks,
Micha
Thank you Micha!
It was because of the "=" in the variable definition... I thought we should always use it but I was wrong...
Thank you very much for you help!
Sofia