Forum Discussion
Not able use <> and = with dates in custom column Function
It looks like there might be a small typo in your custom column formula. Specifically, there's a missing parenthesis at the end of the formula. Here's the corrected version:
= if [#"Convereted - Rejected Date"] <> #date(1970, 1, 1) and [#"Converted - Offered Date"] = #date(1970, 1, 1) then "Rejected by us" else "Not Rejected"
Make sure to add the closing parenthesis at the end of the formula. If the issue persists, here are a few additional troubleshooting steps:
Data Types: Ensure that the data types of your date columns are consistent and correctly set. If the data types are not matching, the comparison might not work as expected.
Spaces in Column Names: It seems there might be a space in the column name "Converted - Offered Date". Make sure there are no extra spaces in the column names, and they match exactly with the column names in your data.
Data Values: Check some sample values in the columns "Convereted - Rejected Date" and "Converted - Offered Date" to see if there are any unexpected values that might be causing the condition not to be met.
If the issue still persists, providing more details about the data or any error messages you are encountering would be helpful for further assistance.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.