Forum Discussion
- ChrisChrisQrew Assistant CaptainFormula Numeric field would go like --
if(
isnull([ship date]),
weekdaysub(Today(),ToDate([order date])),null
) - ScottGrahamQrew TraineeThank you for the help. I am getting the following error.
The types of the arguments or the number of arguments supplied do not meet the requirements of the function ToDate.
The function ToDate can be used with the following arguments:- ToDate (Text x).
- ToDate (Text x, Text f).
- ToDate (Date/Time x).
- ChrisChrisQrew Assistant CaptainThe [Order Date] field may already be a Date type, so just remove the function ToDate() that is wrapped around the [Order Date] field.
- ScottGrahamQrew TraineeSo this is what I have now and it is not returning a value.
if(isnull([Ship Date]),
weekdaysub(Today(),([Booked Date])),null
) - ScottGrahamQrew TraineeI was able to get it to work by changing the formula type. Thank you!
- ChrisChrisQrew Assistant CaptainI believe it has to be formula numeric. Thanks for the follow up.
- MichaelBarrowQrew CadetCheck the setting on your Ship Date field for "Treat blank values as '0' in calculations". Make sure that is unchecked.