Date Formula - IF Statement Error
I have a date- formula field with the below working if statement: If(IsNull([PO Issue Date]) = false, WeekdayAdd([PO Issue Date], [Lead Time +Transit Time (Weeks)]*7), WeekdayAdd([Plan Issue PO D...
Forum Discussion
There were some missing parenthesis and various other things. You probably don't even need all the ones I left in there.
You can try this but it's obviously not tested as I don't have those fields.
If(
IsNull([PO Issue Date]), WeekdayAdd([PO Issue Date],
([Lead Time +Transit Time (Weeks)]*7), WeekdayAdd([Plan Issue PO Date],
isNull([Lead Time +Transit Time (Weeks)]), todate("jan 1, 1900"),
([Lead Time +Transit Time (Weeks)]*7))
You can try this but it's obviously not tested as I don't have those fields.
If(
IsNull([PO Issue Date]), WeekdayAdd([PO Issue Date],
([Lead Time +Transit Time (Weeks)]*7), WeekdayAdd([Plan Issue PO Date],
isNull([Lead Time +Transit Time (Weeks)]), todate("jan 1, 1900"),
([Lead Time +Transit Time (Weeks)]*7))