Skip to main content
Solved

Formula Date-Like Field Not Recognized In Calendar

  • March 19, 2021
  • 2 replies
  • 29 views

Forum|alt.badge.img+1

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

Best answer by kuovonne

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

2 replies

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • Answer
  • March 19, 2021

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


Forum|alt.badge.img+1
  • Author
  • New Participant
  • March 19, 2021

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