Skip to main content
Question

Date Formula - IF Statement Error

  • July 22, 2019
  • 0 replies
  • 91 views

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 Date], [Lead Time +Transit Time (Weeks)]*7)))


I want to add in an initial if statement for If [Lead Time +Transit Time (Weeks)] is null, then show either 0, 1/1/1900, or " " in the field but keep getting an error.
    This topic has been closed for replies.

    • AustinK
    • Quickbase Alumni
    • July 22, 2019
    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))

    Forum|alt.badge.img+12
    • LauraThacker
    • Quickbase Alumni
    • July 22, 2019
    You had an error in the first part of your IF statement.  This should give you the output you are looking for.

    If(IsNull([Lead Time +Transit Time (Weeks)]),null,
    If(IsNull([PO Issue Date]), WeekdayAdd([PO Issue Date], [Lead Time +Transit Time (Weeks)]*7), WeekdayAdd([Plan Issue PO Date], [Lead Time +Transit Time (Weeks)]*7)))
    Laura Thacker (IDS) laura@intelligentdbs.com (626) 771 0454
    Terms & ConditionsAccessibility statement