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

Formula Date-Like Field Not Recognized In Calendar

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

Hi, first of all new here :grinning:

I’ve searched in the comunity and nothing really answers my question

I have a formula

DATETIME_FORMAT(DATEADD({Data Pagamento 1},{Produção Dias},‘days’),‘DD/MM/YYYY’)

When I go to calendar I cannot select that field.

Am I doing something wrong?

I also thought of the possibility that the fact of being a “formula field” does not let the app recognize it as date, even though it is. So I thought a work around that I don’t know how to apply

Create a second “date field” which value is equal to the formula.
I thought maybe with … automation? :roll_eyes:

I tried but I wasn’t able to find such function.

“Date Field” = “Formula Field”

Thanks
Juan

1 Solution

Accepted Solutions

DATETIME_FORMAT turns your date object into a text string. Remove that part and you will have a date object that the calendar will recognize.

DATEADD({Data Pagamento 1},{Produção Dias},'days')

See Solution in Thread

2 Replies 2

DATETIME_FORMAT turns your date object into a text string. Remove that part and you will have a date object that the calendar will recognize.

DATEADD({Data Pagamento 1},{Produção Dias},'days')

Great, it worked!
Thanks for the fast reply :grinning: