Workdate Formula Error

Question

This formula, which is defining a formula workdate field, works fine, unless the end result is to pull from a workdate field:

If ((Trim([Predecessors])="") and (IsNull([Start])), [Date Created],
[Start]
)

If I replace the last "[Start]", which is a workdate, with "[Date Created]", then the formula works. As is, though, I get a formula error for bad or missing function call. Is this a bug, or am I missing something?

quickbasecoachd · Answer

Date Created is a date time/field type.&nbsp; A work date does not have the concept of the time of day.Do you want your result to be a date or a date/time or a workdate?

yehudahgreenber · Answer

That's what is confusing me.&nbsp; Date Created works fine in this formula, it's "start" that is giving me trouble.&nbsp; For example, if I would get rid of the last line, it displays date created without a hitch.&nbsp; (And it would functions a workdate is regards to predecessors.)The truth is that I WOULD like the best of both worlds- Date created (not a workdate) if no other date is defined, but otherwise, a workdate.

yehudahgreenber · Answer

Sorry for the gibberish in the parentheses.&nbsp; Read:&nbsp; It would function as a workdate in regards to predecessors.&nbsp;&nbsp;

quickbasecoachd · Answer

What happens if you convert the [date created] field to a date result with ToDate([Date Created])

yehudahgreenber · Answer

If I do that and leave everything as is, I get the same error.

Forum Discussion

Workdate Formula Error

Related Content

Delete Formula Button Error

404 Error on new nav

Formula Assistance

Formula Url Buttons

Formula Date Field