script to rename a field

[Anonymous]

Hi folks,

I have a spreadsheet with two different date columns. One is called BookDate, the other is InvoiceDate. I am creating a new field BookActionYear= Year(BookDate) but when BookDate is null, BookActionYear=Year(InvoiceDate).

Could you help me with the script please...?

[maxgro]

if(len(trim(BookDate))=0,   InvoiceDate,    BookDate) as BookActionYear

[srchilukoori · Accepted solution]

Massimo Grossi is correct. just a small change.

IF(len(trim(BookDate))=0,   Year(InvoiceDate),    Year(BookDate)) As BookActionYear;

SC