Hi ,
I'm using QB & struggling to complete my formula with a date.
Basically I want to write:
==> If([Release Date (Manual)]<>null,ToDate([Release Date]),[Release Date (Manual)]
So 'if the Manual field is empty, take the normal release date field, otherwise: take the manual field'.
--> However, it's giving an error on the red part: "Expecting text/datetime/workdate but found date"
What am I doing wrong :( ? Thx !
+7You should be able to use [Release Date] without converting it. Unless this formula field is something other than a Date field. Also, isNull() accepts a Date field.
*assuming you've posted the complete formula, as there is no closing paren, you could also write it as:
If(
isNull( [Release Date (Manual)] ), [Release Date], [Release Date (Manual)]
)
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
