Ajustar la columna personalizada de comparación de fechas, tener en cuenta los valores "N/A"

Hola, @rosamhernandez1

Puede probar los siguientes métodos.

Custom = if ([Projected In Service Date] = null or [Network Upgrades Completion Date] = null or [Approved Regulatory ISD] = null or [Interconnection Facilities ISD] = null) then "blank"
    else if [Network Upgrades Completion Date] = "N/A" then
    (if [Approved Regulatory ISD] <= [Projected In Service Date] and [Interconnection Facilities ISD] <= [Projected In Service Date] then "Green"
       else if [Approved Regulatory ISD] > [Projected In Service Date] and [Interconnection Facilities ISD] > [Projected In Service Date] then "Red"
       else "Yellow")
    else if [Approved Regulatory ISD] <= [Projected In Service Date] and [Interconnection Facilities ISD] <= [Projected In Service Date] and Date.FromText([Network Upgrades Completion Date]) <= [Projected In Service Date] then "Green"
    else if [Approved Regulatory ISD] > [Projected In Service Date] and [Interconnection Facilities ISD] > [Projected In Service Date] and Date.FromText([Network Upgrades Completion Date]) > [Projected In Service Date] then "Red"
    else "Yellow"

¿Es este el resultado que esperabas?

Saludos

Equipo de apoyo a la comunidad _Charlotte

Si esta publicación ayuda, considere Acéptalo como la solución para ayudar a los demás miembros a encontrarlo más rápidamente.