Forum Discussion
Helper IExpression.Error: We cannot convert the value #date(2025, 12, 31) to type Logical
good afternoon! I've got the following Custom Column:
if [Approved Regulatory ISD] or [Interconnection In Service Date] or [Projected In Service Date] = null then "blank"
else if [Approved Regulatory ISD] & [Interconnection In Service Date] <= [Projected In Service Date] then "Green"
else if [Approved Regulatory ISD] & [Interconnection In Service Date] > [Projected In Service Date] then "Red"
else "Yellow"
and I am getting an error:
I've verified the data is formatted as a date, but can't resolve the date format error.
Hi rosamhernandez1
Rewrite it as below.if [Approved Regulatory ISD] = null or [Interconnection In Service Date] = null or [Projected In Service Date] = null then "blank" else if [Approved Regulatory ISD] <= [Projected In Service Date] and [Interconnection In Service Date] <= [Projected In Service Date] then "Green" else if [Approved Regulatory ISD] > [Projected In Service Date] and [Interconnection In Service Date] > [Projected In Service Date] then "Red" else "Yellow"
Let me know if this helps.
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Follow me on LinkedIn!!!
2 Replies
NaveenGandhiMemorable Member
Hi rosamhernandez1
Rewrite it as below.if [Approved Regulatory ISD] = null or [Interconnection In Service Date] = null or [Projected In Service Date] = null then "blank" else if [Approved Regulatory ISD] <= [Projected In Service Date] and [Interconnection In Service Date] <= [Projected In Service Date] then "Green" else if [Approved Regulatory ISD] > [Projected In Service Date] and [Interconnection In Service Date] > [Projected In Service Date] then "Red" else "Yellow"
Let me know if this helps.
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Follow me on LinkedIn!!!
rosamhernandez1NaveenGandhi , adjusted the formula to include a third value [Network Upgrades Completion Date], now have to account for "N/A" in this column - we'll still have blanks in the same field, advise?
Project Name Projected In Service Date Approved Regulatory ISD Interconnection Facilities ISD Network Upgrades Completion Date Warsaw 9/30/2024 9/30/2024 7/19/2024 N/A Monroe 12/31/2024 12/31/2024 1/15/2025 Suwannee 2/28/2025 11/30/2024 Riverside 9/25/2025 8/30/2024 12/31/2022 Elm City 9/30/2025 9/30/2025 6/30/2025 N/A Knightdale (Wake) 9/30/2025 9/30/2025 5/30/2025 5/30/2025 Longtown 12/31/2025 9/30/2025 2/27/2026 Nebo 12/31/2025 9/30/2025 3/31/2026 Allen 1 12/31/2025 12/31/2025 10/31/2025 Asheville (fmr. Lake Julian) 3/31/2026 3/31/2025 8/15/2025 12/1/2024 Craggy 3/31/2026 3/31/2026 12/1/2025 N/A New Hill 12/31/2026 6/30/2026 6/2/2025 Powerline 3/1/2027 6/1/2029 Williamsboro 6/30/2027 3/31/2031 Coleridge 9/30/2027 3/31/2031 Riverbend 10/1/2027 5/21/2027 N/A Mayo 12/31/2027 3/31/2031 Wilkes 12/31/2027 10/1/2027 10/1/2027 HF Lee 4/1/2028 6/2/2028 12/2/2029 HF Lee 2 10/1/2028 4/2/2029 if [Approved Regulatory ISD] = null or [Interconnection In Service Date] = null or [Projected In Service Date] = null then
"blank"
else if [Approved Regulatory ISD] <= [Projected In Service Date] and [Interconnection Facilities ISD] <= [Projected In Service Date] and [Network Upgrades Completion Date] <= [Projected In Service Date] then
"Green"
else if [Approved Regulatory ISD] > [Projected In Service Date] and [Interconnection In Service Date] > [Projected In Service Date] and [Network Upgrades Completion Date] > [Projected In Service Date] then
"Red"
else
"Yellow"