Help

Re: Date formula not working ....

Solved
Jump to Solution
1172 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Steve_Fleck
5 - Automation Enthusiast
5 - Automation Enthusiast

I don't understand why this formula isn't working ... I can only think it has something to do with the Now() calculation.

IF({Quote Status}="Selected" And(Now()) > {Scheduled Date},
     {Scheduled Date},
     IF({Quote Status} = "Fulfilled",
          {Adj. Fulfilled Date},
          {Dummy Date})
   )

 

Any thoughts?

 

 

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

Here's how to use AND in Airtable.

IF(
   AND(
      {Quote Status}="Selected",
      Now() > {Scheduled Date}
   ),
   {Scheduled Date},
   IF({Quote Status} = "Fulfilled",
      {Adj. Fulfilled Date},
      {Dummy Date}
   )
)

See Solution in Thread

3 Replies 3
Steve_Fleck
5 - Automation Enthusiast
5 - Automation Enthusiast

I did check the time zone in the date fields and they are all the same.

Sho
11 - Venus
11 - Venus

Here's how to use AND in Airtable.

IF(
   AND(
      {Quote Status}="Selected",
      Now() > {Scheduled Date}
   ),
   {Scheduled Date},
   IF({Quote Status} = "Fulfilled",
      {Adj. Fulfilled Date},
      {Dummy Date}
   )
)
Steve_Fleck
5 - Automation Enthusiast
5 - Automation Enthusiast

Sho! Thank-you!
I would NEVER have solved it without your help.