Forum Discussion

DN2725's avatar
DN2725
Qrew Member
2 months 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...
formulas
Mez's avatar
Mez
Qrew Cadet
2 months 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)] 

)