Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have the following problem: my table contains a column "Type" that contains values A, B or C. Values A or B always have their date in column "date1", value C always has the date in column "date2".
I want to combine those two date fields to create a new column "new date" that contains the values of both columns.
I used the following formula to create a new column but it does not seem to work: =If(Type='A' or Type='B', date1, date2). With this formula it only shows date1 in my new column but the values for date2 are null.
Can anyone help me?
Thank you very much!
alt(date#( date1 , 'YYYY-MM-DD' ),date#( date2 , 'YYYY-MM-DD' ) as "New Date"
alt(date#( date1 , 'YYYY-MM-DD' ),date#( date2 , 'YYYY-MM-DD' ) as "New Date"
Thanks Ogster1974, that works perfectly!