Get updated data using expression

[bsbernabe]

Hello There,

My concern is how to get the updated data and if no update gets the previews data.

sample data:

Name	A	Date	B	Date
MC Sy	Collector	08/25/2016	Branch Name	10/08/2019
Abiah Teng	Cashier	02/16/2017	-
Ashly Tan	Credit Asso.	12/08/2017	Credit Approver	08/28/2019

I try this expression but the output its not working base on the output I need.

If(len(A)>,A,If(len(B)>,B))

The output should be that I need is like below:

Name	B	Date
MC Sy	Branch Name	10/08/2019
Abiah Teng	Cashier	02/16/2017
Ashly Tan	Credit Approver	08/28/2019

Is there any other way for this kind of concern?

Best Regards,

Bing

[jonathandienst · Accepted solution]

Something like:

If(len(B) > 0, B, A) as B,
If(len(Date1) > 0, Date1, Date) as Date,