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))
- I can no longer edit this...
Actually, looking at this formula it looks to be pretty spaghettied to start with so what I did will not work. Can you post a simpler version before you made changes that worked, and then say what you would like it to do?