Date formula not working ....

[Steve_Fleck]

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?

[Steve_Fleck]

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

[Sho · Accepted solution]

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]

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