Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

IF unix date field is blank, manual date field with DATETIME_FORMAT

Topic Labels: Formulas
Solved
Jump to Solution
346 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello Airtable community friends,

It’s been a while! Thanks to some of you, my online book business is running smoothly on Airtable. But I am far from Airtable proficient yet…

Airtable if then date formula

How can I get the Date and Time formula fields to check and see if there’s something in Manual Date & Time first, and then, if it’s empty, turn to Unix Date & Time? I don’t know how to weave the necessary IF statement into the DATETIME_FORMAT I’ve already got set up in the Date and Time fields. I labeled the screenshots 1 and 2 'cause they’re the same, only the second shows the formula I’m using.

Many TIAs for ideas!

1 Solution

Accepted Solutions

EDIT: Nevermind, I misread.

Keep your formula the way it is, except replace {Unix Date & Time} with:

IF({Manual Date & Time}, {Manual Date & Time}, {Unix Date & Time})

See Solution in Thread

2 Replies 2

EDIT: Nevermind, I misread.

Keep your formula the way it is, except replace {Unix Date & Time} with:

IF({Manual Date & Time}, {Manual Date & Time}, {Unix Date & Time})

That did the trick! Thanks for coming to my rescue yet again, Kamille! :slightly_smiling_face: