Forum Discussion

DN2725's avatar
DN2725
Qrew Member
29 days ago

Formula - ToDate

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 !

formulas
  • Mez's avatar
    Mez
    Qrew Cadet
    29 days ago

    You 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)] 

    )