+3Not sure if this is possible as I just started using Airtable.
I created a formula for contracts based on Start Dates and Contract Term that will give me an Automatic Original End Date. Then I have another Field for Bonus weeks which will give me a “Final End Date”
I am looking for a way to make the Final End Date field a Date/Time instead of a Formula field so that I can sort and group a certain way from a Date. Is this possible?
+27By using DATETIME_FORMAT() you are explicitly telling Airtable to “take this date and turn it into a string”. All you need is the DATEADD() portion of your formula, use the “Formatting” tab in your field config panel to control the display order of months/days.
+4Hi @Admin_Department1
As @Kamille_Parks says, just use date add and the format tab - like this:
and
You may also consider modifying the formula to remove the errors if there is no original date:
Hope this helps.
Julian
+5Hi @Admin_Department1
As @Kamille_Parks says, just use date add and the format tab - like this:
and
You may also consider modifying the formula to remove the errors if there is no original date:
Hope this helps.
Julian
Hi, if I use the IF() condition outside the DATEADD(), the formatting tab doesn't work for me.
What should be done to retain the DATETIME data type in this case?
+10
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.