Hi, I have a data with the following dates under the field "Warranty_End_Date"
Warranty_End_Date
Manufacturer
4/1/2026
Lenovo
4/8/2026
Lenovo
1/9/2026
Acer
4/1/2025
Apple
19/7/2023
Acer
4/1/2026
Acer
4/4/2026
HP
8/1/2028
Lenovo
10/1/2022
Lenovo
4/1/2026
Apple
4/1/2026
Apple
4/1/2026
Lenovo
4/1/2026
Lenovo
4/1/2026
Lenovo
4/3/2026
Lenovo
4/3/2026
Lenovo
I want to create a new field with the similar values wrt Warranty_End_Date Tried the command eval WarEnd = case("Warranty_End_Date" = "*2026", "2026", 1=1, "NA") and similarly for other years but got no proper output
... View more