Help

Re: Formula Date-Like Field Not Recognized In Calendar

Solved
Jump to Solution
603 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Juan_Ferrari
4 - Data Explorer
4 - Data Explorer

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
kuovonne
18 - Pluto
18 - Pluto

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
kuovonne
18 - Pluto
18 - Pluto

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')

Juan_Ferrari
4 - Data Explorer
4 - Data Explorer

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