Skip to main content
Question

Null Date Field

  • November 13, 2020
  • 0 replies
  • 307 views

Hey Everyone,

I wanted to see if I could get some Formula advice. I have a formula that takes a start date and adds duration:

WeekdayAdd([Sub Start Date], ToNumber([Gas Pipe Total Duration])-1)

I had to include the -1 because I noticed it starts the count after the start date, but doesn't include the start date. 
But if the total duration is blank or 0 how can I have it not display a date? Right now it's showing the day after start date because of the -1, or just the start date if I remove the -1.

Any tips on this formula?

Thanks,

------------------------------
Alex Bennett
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
try this


IF(Nz(ToNumber([Gas Pipe Total Duration])<>0,
WeekdayAdd([Sub Start Date], ToNumber([Gas Pipe Total Duration])-1))

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------