Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...?
Massimo Grossi is correct. just a small change.
IF(len(trim(BookDate))=0, Year(InvoiceDate), Year(BookDate)) As BookActionYear;
SC
if(len(trim(BookDate))=0, InvoiceDate, BookDate) as BookActionYear
Massimo Grossi is correct. just a small change.
IF(len(trim(BookDate))=0, Year(InvoiceDate), Year(BookDate)) As BookActionYear;
SC