Forum Discussion

MeredithMoore1's avatar
MeredithMoore1
Qrew Cadet
8 years ago

How do I make this work? If( IsNull([Date Complete]) and [Status]=""Completed"",ToDate([Date Modified]), [Date Complete])

This is the formula that I have. I don't know why it keeps throwing errors/ If( IsNull([Date Complete]) and [Status]="Completed",ToDate([Date Modified]), [Date Complete])
Ask about Quickbase functionality
Errors
Formulas and functions
AlinMihalcea1's avatar
AlinMihalcea1
Qrew Assistant Captain
8 years ago
Try adding a ToDate before [DateComplete]
maybe like this?

If(IsNull([Date Complete]) and [Status]="Completed",ToDate([Date Modified]),
ToDate([Date Complete]))