Hello,
this formula is wrong, why? I use it in a calculated field with no problem, i add it in an other field in the same module but throw an error... is it a bug?
If i select the data type date/time can i use only date? And if wrong condition can i leave the field empty, how?
If(Or(Startswith(${Invoices.IVA},'Subito'),Startswith(${Invoices.Prima Scadenza},'30')),Subdate(Adddate(Newdate(Year(${Invoices.Invoice Date}),Month(${Invoices.Invoice Date}),1,00,00,'AM'),2,'MONTH'),1,'DAY'),Newdate(Year(${Invoices.Invoice Date}),Month(${Invoices.Invoice Date}),1,00,00,'AM'))
Best regards, Andrea L.