Help

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

Solved
Jump to Solution
523 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Alba_Machado2
7 - App Architect
7 - App Architect

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
Kamille_Parks
16 - Uranus
16 - Uranus

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
Kamille_Parks
16 - Uranus
16 - Uranus

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: