Forum Discussion
Solved
If condition for DATE
Hello, I am having some difficulty of If condition result. I have two columns: %DATE_KEY int type, which has many non unique rows with dates looking back 5 years, format is always yyyymm&"...
Ah, OK. Then try the same thing except as a number.
if Number.Mod([%DATE_KEY], 10000) = 1201 then [%DATE_KEY] else null
Hello AlexisOlson,
Thanks for Your help, unfortunately %DATE_KEY is integer (number) and it does not work with syntax Text.End.
Ah, OK. Then try the same thing except as a number.
if Number.Mod([%DATE_KEY], 10000) = 1201 then [%DATE_KEY] else null