Date Formulas: The 3 Most Common Date Formulas of Airtable

[@GarethPronovost]

Join us for our *FREE LIVE TRAINING* that teaches the building blocks of automation: www.garethpronovost.com/webinar-registration

[@nutritionalsolutions1872]

Awesome. Question: when you use a formula to create a new field with a "date," does AirTable see that as a DATE field or a TEXT field? For example, could you plug the result of your MaxDate into a calendar view or use it to trigger an automation?

[@susansolomon4463]

I can hug you through the screen, your video just helps me figure something out that i have been trying all day

[@kristibontrager6124]

Thank you for showing DATE ADD! I've been trying to figure that out for a year.

[@Girlonthemattress]

You're too good!! I love watching your tutorials 🙏I always learn something powerful and valuable, and you're so genuine and clear about your teachings! THANK YOU!!!

[@GarethPronovost]

Thanks for watching! So glad to help!

[@studenthousingthehague9326]

Thank you very much for sharing your knowledge!

[@HeatherHale]

You. Are. A. Stud. Every time I Google an Airtable question ... there you are! ;-) Generously sharing your knowledge in quick, concise, helpfully timecode-referenced videos that SOLVE my immediate problem and get me swiftly - and MORE functionally EMPOWERED - back on my way / to my day. BLESS YOU! ;-)

[@GarethPronovost]

Woohoo! Thanks Heather! :)

[@TheArtBeaconTAB]

I learn more from your tutorials than many other instructors. Mostly due to your approach, i.e. you tell us what you intend to accomplish (whether it is the subject of the whole video or a specifi leg of a formula), then show us how to do it and why (many people leave that part out), then follow up with an overview. You also explain terminology which helps me to absorb the concepts. Thank you!

[@GarethPronovost]

Awesome! Glad my approach resonates with you! 👍

[@santiagoarsuaga369]

Hi!, thks for sharing. I have 1 question. Could it be possible to create a field that can show me the due date minus 20 days? for example i have in one field the time of days that would take for the production of a box. Then i have my due day of the product on ##/##/####. So, i need my limit day to send the approval of the production, I learned to plan from the due day backward. ????

[@GarethPronovost]

Hey Santiago - sure thing. Try this formula: DATEADD( {YOUR DATE FIELD HERE} , -20 , 'days' ) The output here will be 20 days before the date field that you reference!

[@santiagoarsuaga369]

@@GarethPronovost thx for answering...

[@ancestrycounts4759]

Thank you, that's what I've been trying to do and couldn't get it to work!! I am calculating the estimated DOB (date of birth) when you know the person's age at a given date. For instance, on 1/1/2020, I'm 59 years old. I have the date field, then added a number field to enter the age (for the count value). My formula DATEADD({Known Date},-({Age at Known Date}),'years'). The formula calculated 1/1/1960. That's true I was born in 1960. This is useful for genealogists to calculate an estimated birth year from historical records that list the person's age and date of the record, like census records! I have been going out to websites that had date calcs, but now I can do it right in my airtable genealogy research log.

[@GarethPronovost]

So glad this helped!

[@GabrielaHiga]

you saved my life, thank you!!!!

[@GarethPronovost]

I'm so glad, thanks for watching! :)

[@theyogabios]

Thank you Sir.

[@tonyromero4142]

Thank you so much for your tutorials. I have a question. Is there a way to have airtable count down the days from say Date 1 to Date 2? Im trying to trigger an email notificatiion with zappier once lets say this "countdown " of days hit 0. For follow up on a CRM Base .

[@GarethPronovost]

Definitely - check out the DATETIME_DIFF() formula to calculate the number of days between two dates!

[@mahuidacatrileo4784]

Excelente tutorial! Justo lo que necesitaba para mi planilla. Muchas gracias ♥️

[@GarethPronovost]

Glad to help!

[@ChristopherBerndt]

Thanks, awesome

[@GarethPronovost]

Thanks for watching!

[@EviKylafi]

Very interesting but if someone takes vacations on 12-13/2/2022 those are 2 days , meaning leaves on 12 and returns on 14/2 at work. the airtable counts it as 1 days. is there a formula in order to count the days from the date we put? thank you

[@c.a.4726]

how do i do a date add formula that factors in weekends and holidays?

[@contractorguys4932]

Is there a way to contact you and hire you to answer a question without having to wait for the free consultation?

[@GarethPronovost]

sure - shoot me an email at [e-mail]

[@stevevo4493]

Hi Gareth, How to write a formula to have current date display in a cell? ie, whatever the current date will be displayed? Let's say today is 01/02/2019 and tomorrow the cell will be charged to 01/03/2019, thanks!

[@vivekvachhani751]

How we can custumize the only time(NOT WITH DATE) in airtable. Please make one video on this topic.

[@GarethPronovost]

I'll add it to the list! :D

[@edwardpaddon160]

Hi Gareth, I am trying to record modifications to a record as the status changes. This is so I can see how long the project spent in each phase. I want to be able to see the dates that each change to the status occurred, not just the most recent change. I would phrase my formula in my head as: If Status changes, record date. Currently I can record status modifications but this only shows the most recent change to the status and so does not reflect how long the project spent in each status phase. Do you know of a way to do this?

[@GarethPronovost]

You can build a secondary table that creates a linked record every time it detects a change in the primary record with an automation

[@soldier-br1mn]

Hi... How can i change time zone in airtable?

[@TinaCrawford-j4e]

Is there a way to change a date to the first of the month? I.e. an event starts on 6/12/2023 but I want to change that to 6/1/2024.

[@TinaCrawford-j4e]

I think maybe I figured it out... hopefully it will keep working unlike our other attempts! 😂

[@GarethPronovost]

Definitely with some formula magic - hoping you got the fix!

[@kwengmedia1698]

Can we put day in airtable.

[@JasonTRogers]

For those looking for the Article he was reviewing here is the link support.airtable.com/hc/en-us/articles/216141218-Supported-format-specifiers-for-DATETIME-FORMAT

[@GarethPronovost]

Thanks Jason!