Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Date formula not working ....

Topic Labels: Dates & Timezones Formulas
Solved
Jump to Solution
1385 3
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.