Question:
Hi!
the problem come to use this sentence in a Formula for Update Rules:
DATE_FISCYEAR( CRM_EXPEND , FISCVARNT)
CRM_EXPEND --> it's in format YYYYMMDD
FISCVARNT --> contains 'FY'
I tried to insert it into an "IF" like this:
IF ( ID <> '', DATE_FISCYEAR( CRM_EXPEND , FISCVARNT), '')
ID --> Always contais anything
It doesn't give Syntax Error, but when i start the load, it fails.
Somebody cauld help me to resolve this... thx.
Answer:
It's no neccesary use this way, if somebody knows another manner to do this, i'll be grateful so much too.
Thx.