Forum Discussion
Filter out date values before year 2000
Hi, How can I filter in Query that if the date values before year 2000 then replace to null value? FYI, sometimes raw data has values with 1900-01-01 which is actually no value so I wanna filte...
do you know reason I cannot filter in order?
Deku
Super User
Super Userworks for me
I think that code got error when initial value is null.
Can we create 2 conditions:
1. if value null then null.
2. if value before year 2000 then null.
if value doesn't meet above conditions then keep it as it is.