Forum Discussion
bcbuckley13
6 years agoHelper III
Error when no Completion date
Hello, I've created two columns. One is a Custom column that just adds 30 days to the Reg Date (Due Date). The "Completed in 30?" column is a Conditional column to see if the user completed the cour...
- 6 years ago
Hi bcbuckley13 ,
You have to start the if with nulls.
The if should be something like if [Course Complete Data] = null then ........
write the other conditions with if else / else.
mahoneypat
6 years agoMicrosoft Employee
From the image, your Due Date is still an Any data type. Change it to Date to see if that fixes issue.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
bcbuckley13
6 years agoHelper III
Thanks, but that didn't work.