Forum Discussion
Query Editor: IF Date < then empty
Hi, I never work with Query Editor much, so I'm not sure how to do this. I have a date field from a very old system, which doesn't know blank/null values. Meaning that if a date field is empty i...
I actually found a way because you made me think of it.
= Table.ReplaceValue(#"Replaced Value",#datetime(1753, 1, 1, 0, 0, 0),null,Replacer.ReplaceValue,{"ARCHIEF_DATUM"})
I actually found a way because you made me think of it.
= Table.ReplaceValue(#"Replaced Value",#datetime(1753, 1, 1, 0, 0, 0),null,Replacer.ReplaceValue,{"ARCHIEF_DATUM"})
You can also refer to this link.