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?
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?